Hi, For some odd reason I have to work on exporting data from SQL 2008 DB to FoxPro .dbf files. I have to design SSIS package for it. What should be the approach to go about it. What I can think of is, while exporting data, keep checking the .dbf file size after every record and as soon as it reaches close to 2GB, create a new file. I need to automate this process of creating additional files, of less than 2GB each, numbered in a sequence, for instance, FoxproFile1.dbf, FoxproFile2.dbf and so on... To me it seems to be a tedious task. So thought would seek help. Thanks.

Hello Amar09, the biggest challenge is to check the size. IMHO, if you know the record size and it is more or less static then you can just do the math and set the MaxNumberofRows property on the Data Flow to limit it. So you would end up dumping a certain amount of rows into a file in a loop, and then when you are near the upper threshold generate a new file by renaming the old, and template file (execute process can do the rename).Arthur My Blog

Thanks for the reply. The record length is too variable, can range from 200 - 17000 bytes randomly. For file size I have found File Properties Task which will check after every few hundred records the size of file and stop near the upper threshold. After this my challenge is to dynamically create the file names when we move to next file, post the threshold is reached.