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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy