SSIS Package running slowly but not when running query directly in Query analyzer

Jan 21, 2015 at 8:42 AM
Hi
I am facing performance issue when I am running ssis package from BIDS,it is taking around 2 hours to complete the loading , and when the same query running from query analyzer it is taking 1 minute to complete.

I am using sql servr 2012.In my package data coming very slow on OLEDB Source.
Please help me to resolve the issue.
Regards,
Vipin jha
Coordinator
Jan 22, 2015 at 7:03 AM
Edited Jan 22, 2015 at 7:03 AM
This question isn't related to BIDS Helper so is best asked at http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

However BIDS Helper does have a feature which may help you get to the bottom of the performance issue. Try:
https://bidshelper.codeplex.com/wikipage?title=Pipeline%20Component%20Performance%20Breakdown&referringTitle=Documentation
Marked as answer by furmangg on 1/22/2015 at 12:03 AM