This project has moved and is read-only. For the latest updates, please go here.

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

Jan 21, 2015 at 9:42 AM
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.
Vipin jha
Jan 22, 2015 at 8:03 AM
Edited Jan 22, 2015 at 8:03 AM
This question isn't related to BIDS Helper so is best asked at

However BIDS Helper does have a feature which may help you get to the bottom of the performance issue. Try:
Marked as answer by furmangg on 1/22/2015 at 12:03 AM