sql server dts: Export to more than one Excel file. Each one with 10000 rows -- sql server dts

Export to more than one Excel file. Each one with 10000 rows

Carmen
10/23/2007 8:55:03 AM

sql server dts: I have to export a table to an Excel file. I must generate a new Excel file
every 10000 rows.

Any help will be appreciated.
Thanks in advance.

Re: Export to more than one Excel file. Each one with 10000 rows

Francisco A. Gonzalez
10/24/2007 12:00:00 AM

Ok you can use a for each loop, and then use an Execute SQL Server task, to
get the first 10000 thousand to a temp table and delete it from source if
necesary, then a data flow to create the excel file from the temp table, and
like this over and over until the SQL server task says there is no more
data, then the variable is update and you get out of the for each loop.

this is one option, but you have to be carefull with concurrency in the
source table.

cheers

--

Francisco A. Gonzalez
fgonzalez@solidq.com

[quoted text, click to view]