September 26, 2012 at 2:18 pm
Hello,
My team has development a unit testing tool that we have come to depend on heavily. We original developed this in VS2008. Recently we have moved to VS2010 for all of our development work. We are now getting upgrading our unit test tool. The migration was successful but the performance was horrible. We were able to trace the slowness to where we call an SSIS package. From the unit test tool it takes 15-20 minutes to run the package. That same package run from VS2008 (it is a SQL Server 2008 R2 SSIS package) takes 30-40 seconds. Nothing has changed about the package, the unit test tool, or the databases involved. The only thing that has changed is that we are running the unit test tool in VS2010 instead of VS2008. Any suggestions on how to speed this up would be very helpful.
Thanks.
September 28, 2012 at 12:07 pm
After some trial and error I found a partial answer to my problem. The package I was calling was a parent package. If I called the child packages directly they would load and run much faster. It still wasn't as fast as when running in VS2008; now it was perhaps 25% longer than VS2008.
I have not been able to tell whether the problem with the first package is that that it calls the other packages or if there is something in the package itself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply