October 12, 2011 at 6:44 am
Hi All,
My source and destination server are 64 bit, sql server 2008. when I'm importing data using sql import export wizard its taking 9 hours to import 135005546 rows. Now I make a job of ssis pkg to import the same data, dramatically the performance goes down and now its taking 38 hours to import the same data. I didn't use any trasformation in the package, it have source and destination. both connections are OLEDB.
Thanks
Sneh
October 12, 2011 at 6:47 am
Can you provide some more information please?
Package configuration / properties?
Thanks
Chris
October 12, 2011 at 7:01 am
even I checked, when I'm running in BIDS its fast. but if I run the job its slow. the destination has "table or view- fast load" max insert commit size is 2147483647. the package on only two transformation -1) OLEDB data source and 2) OLEDB data destination. please let me know this help you to debuging
October 12, 2011 at 7:09 am
Are thier resources avaiable on both source and destination servers?
October 12, 2011 at 7:23 am
yes
October 12, 2011 at 7:34 am
please see the following link. I'm facing the same problem but in sql 2008 Environment
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply