Bhaskar.Dasari
Grasshopper
Points: 12
More actions
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
pritesh2205
Ten Centuries
Points: 1355
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.
Ananth-431739
Points: 1185
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