Post reply

Archiving old data in CSV file

  • October 11, 2010 at 1:15 am

    #227539

    Hi,

    I have a huge table that is growing very fast (500000 row per day )

    I need to keep data in this table for only the last 3 months and to move each day before that to CSV file in a daily schedule.

    do you I have to use SSIS, if yes how if no what is the best practice way to do this?

    Note: I have to avoid the lock on this table because of many transactions per sec.

    thank you.

  • October 11, 2010 at 7:35 am

    #1234977

    hi,

    Thank you for your help,

    I'm facing a problem with bcp to add double quote for each nonnumeric filed, and I prefer the SSIS Which is more professional and usefull but I need to know how to do it in SSIS or a solution for the double quote problem

    thank you

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

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