question

FLSchmidtK avatar image
FLSchmidtK asked

SSIS Package VERY SLOW!!

so I put together my first package to get data from a sql table, convert it to datetime, output errors to excel, and put the good data back into a new sql table. It takes flippin forever, why?? No indexes on the table because it's raw data, but please let me know if this would be faster. doing date conversions on 4 columns. Thanks in advance!
sql-server-2005ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aRookieBIdev avatar image
aRookieBIdev answered
Hi, I guess you are using the Data Flow Task.Try increasing the values in properties DefaultBufferMaxRows and DefaultBufferSize. I hope you are using SQL Connection instead of Oledb Connection. Hope this helps. Thanks, Kannan
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

FLSchmidtK avatar image FLSchmidtK commented ·
ummm...i guess i'm busted...it's oledb. i'm a newbie at this, so what's the difference. Thanks for the quick response.
0 Likes 0 ·
Daniel Ross avatar image
Daniel Ross answered
Hello, What part of the package is slow? Is it slow loading data, or are the transformations slow, etc. when the package completes look in the progress tab and you can expand each component and see the execution times. BTW, i don't think that the OLEDB connection is causing your speed issue, I never use the SQL connection..always OLEDB for me. I find that the SQL connection is not as useable as the OLEDB connection, especially when is comes to using variables.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.