July 18, 2016 at 9:14 am
I am building a project where I have a source data set (SQL View) that has roughly 190,000 rows. When I Select * From View, it returns the data in 3-5 seconds.
When I try to retrieve the data using SSIS, it returned less than 5,000 rows in about 4 minutes. I killed the process after that because it was taking so long.
Any ideas on what my issue could be?
Thanks
July 18, 2016 at 9:22 am
Where are you running the query, and where are you running the package?
John
July 18, 2016 at 9:23 am
AS a follow-up.
The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When doing the same with the view (which consists of the exact same SQL) it took almost 5 minutes for 4600 rows.
July 18, 2016 at 11:10 am
mbrady5 (7/18/2016)
AS a follow-up.The view seems to be the issue. When taking the SQL from the view, it imports in less than 10 seconds using the SQL import wizard. When doing the same with the view (which consists of the exact same SQL) it took almost 5 minutes for 4600 rows.
Should be the same. I'd suggest that you compare the execution plans for each and see whether that gives you any clues. There may be a SET option in there that's causing things to be evaluated differently.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply