Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS Export by record count

Author  Topic 

Jsolomon
Starting Member

13 Posts

Posted - 2010-11-03 : 16:28:27
I have a sql DB with 10 million records. I have a ssis package that will export to a flat file. What I need is to export to a group of flat files based on rows. I need each flat file to have no more than 750,000 records each. Each time count reaches 750,000 start a new file until end. Any ideas? All the stuff I have read looks for some value in a column.
   

- Advertisement -