DTSX Package Running Slow
Posted on 2010-03-24
I am a sys admin with what appears to be an app problem. I want to start with that is is NOT a resource problem (well actually it is, but there are plenty of resources the app just isn't using them). It is SSIS running on Windows and SQL 2008 server. The problem lies in only one package for this one app. When the dtsx package is run on the server it takes forever to run compared to how the same package runs on the 2003 box. What it boils down to is that it appears the package is not taking the resources it needs to run so even validation is very slow. It barely takes 100k of memory and chugs. So I am wondering if something different needs to be done to the dtsx package to run on Windows 2008 64-bit. The BI app person is convinced it is the OS. The SQL team doesn't think it is their problem. I am an OS person, not an app person or a DBA. Any thoughts would be appreciated.