I have a request to split an existing text file output directly from a table into separate files in groups of 10k records. I already have a rowid (identity) in the table, now I am struggling with how to design a DTS to accomplish task. The table which presently feeds the existing single output text file; has ~60k rows. But, this can be dynamic and we may have 100K rows next month. The whole reason for this 10k per file is to accomodate another program which can appearently only run 10k records per modeling run. I plan to store the 10K max records per text file in a default lookup table; since it may change. Any design thoughts appreciated.
Steve Medvid
IT Consultant & Web Master
Chester County, PA Residents
Please Show Your Support...
Steve Medvid
IT Consultant & Web Master
Chester County, PA Residents
Please Show Your Support...