Exporting a table into multiple text files based on rows


  • Hi,

    First of all, I'm very bad at SSIS and has hardly never used it, so bear with me.

    I have this table, with about 8 million rows in SQL Server, and I would like to split it into four different text files, with about 2 million rows per file. I'm thinking conditional split, but I do not know how I can base the export on how many rows that is processed. Can anyone help me...? 
    Friday, June 5, 2009 1:48 PM