November 2, 2010 at 10:45 am
i have a package with a data flow task that has an OLE DB source and OLE DB Destination. In the OLE DB Source is a SQL query that is pulling records from a table which will be used to insert into the OLE DB Destination table. My query is returning over 2.1 million records and every time my package gets to this task it hangs, so the query query in the OLE DB Source executes but when it's about to insert into the OLE DB destination table it hangs at row 9000 something and the task stays yellow and stays at the number of rows count forever not inserting anything in my destination table even after letting it run for a good 2 hours.
Now if I were to take this query and run it in management studio it finishes in less than a minute and rows are inserted in that destination table so it's not like the query is not optimized to perform the record retrieval and then insert.
Does anybody know why this is happening?
November 2, 2010 at 2:31 pm
A couple of things could cause this issue that I've run into...
-A blocking issue...perhaps inserting to the same table that you are extracting from as your source
-Commit size on the destination component
-Buffer size
Hard to diagnose without knowing details of what else is going on in the package and what the properties are on your destination.
November 2, 2010 at 2:47 pm
As was said above, it could be a blocking issue.
One way this could easily happen is if you destination table is part of the select query in the source.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
November 3, 2010 at 10:17 am
Please check if this helps.
Thanks
SQLRocks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply