Loading data into different text files from a single table in SQL Server

Reply

gvamsimba Posted: 08-24-2009 12:03

rated by 0 users

HI, I have a table in sql server 2005 which has a flag column.
Now, i need to create a SSIS package when needs to load
the data from this table into MULTIPLE Text files
based on the flag numbers in my source table.

   I have attached my package which is loading the data from
my table to a single text file along with my source schema. Can any body please modify
it so that the data will be loaded into multiple text files ?

Many Thanks

2548.Loading data into different files from a single table.txt3718.Mytable.txt

Reply

PedroCGD replied on 09-07-2009 12:45

rated by 0 users

Hi!

Sorry for the late answer...

Could you please attach the script table for source?

Also, could you tell me the condition to split the data into different text file destinations.

Regards,

Pedro

Reply

gvamsimba replied on 09-09-2009 11:44

rated by 0 users

HI Pedro, I have already attached my package and the source
table in my previous note, if you have a look..
the conditon is the cell number..for instance cell no 10
will go into a different text file and cell no 12 into
another and so on...

Many Thanks..

Reply

PedroCGD replied on 09-09-2009 11:52

rated by 0 users

Hi!

You attached the data not the create table script with schema!

Regards,

Pedro