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?