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

  • 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

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

  • 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