Post reply

Which task is best for loading many rows(million) in to database or flatfile

  • March 24, 2008 at 12:50 am

    #121075

    Hi,

    i have to load 1million rows from database( or flatfile) to the database(or flat file).

    which task is used as the best solution for this?

    Appreciate any assistance in this regard.

    Thanks,

    Bhaskar

  • March 24, 2008 at 4:49 am

    #792946

    BULK INSERT task will be ebst suited if you do not want to carry out any transformation.

  • March 24, 2008 at 11:21 pm

    #793332

    You can use bulk insert if you don't have any transformation. otherwise you can use SSIS for transformation.

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

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