October 23, 2008 at 12:54 pm
Hi Friends,
I have an issue with SSIS packages. Let me explain. I have 50 rows in the database table to be manipulated. I have one package with logic to manipulate the data.
The package contains Flow task which read the data from source and lead it into the destination record set. Then I have FOR EACH loop container who reads this data and does the manipulation.
When I run it from BI studio it hardly takes 50 sec. to run but when I deploy it takes nearly 4-5 mins to run which is not at all acceptable.
And this is the issue with most of the packages developed by the team.
There is no problem of hardware we have good PC and using Windows XP with SP3
SQL Server 2005 with SP2.
Help will be appreciated. Thanks in advance.
October 23, 2008 at 1:37 pm
What else is running on your SQL Server when you are running the SSIS packages? Does the SQL Server take the same network routes to the source and destination as the PC on which you are running BIDS?
Have you run perfmon or profiler while the packages are running to determine what may resources my be sources of contention?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 24, 2008 at 12:24 am
Hi Jack,
Thanks for quick turn around. All the development are done on local machine. My SQL Server 2005 & SQL Server Integration Service & BI studio are on same machine so there is no question of network.
I have seen the profiler the queries are taking hardly secinds to run.
My basic question is same Why it run faster while runing from BI studio & when deployed it runs slow on same machine ??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply