Post reply

Splitting the extraction to get smaller files

  • September 16, 2008 at 8:08 am

    #72922

    Hi all,

    i have a problem with the DTS extraction to csv as the volume is very large around 2 million records.

    so can u please give me some tips to break this data into smaller files of around 100000 records in each file and overall around 20 files to be generated...

    Pls, help me...

    Thanks in advance

    charan

  • September 16, 2008 at 2:09 pm

    #872692

    What's the problem?

    Splitting the file must be done with some programmatic code (VBScript or VB or C#). You can commit the file in smaller batches (options in the transform data task.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply