November 1, 2010 at 6:22 pm
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 row are inserted in that destination table.
Does anybody know why this is happening?
November 2, 2010 at 10:47 am
mrtrich99 (11/1/2010)
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 row are inserted in that destination table.
Does anybody know why this is happening?
Please disregard this post/question I think I posted this in the wrong forum.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply