SSIS migration from SSIS 2005 to SSIS 2012
Hi to all, we need to migrate our website from a machine with Windows Server 2003 32 bit with SQLServer2005 and SSIS installed to a new machine with Windows Server 2008 R2 64 bit with SQL Server 2012 and SSIS installed. In this website we have an aspx page to programmatically call a SSIS package. The page works well in Win2003 32 bit environment but we got an exception trying to execute the same page in new machine Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Can someone suggest us how to solve this issue? Thank you in advance for your help. Best regards Fabrizio
May 17th, 2012 10:23am

You need to reference the new Microsoft.SqlServer.ManagedDTS which is version 11, rightfully you got that this old DLL is missing b/c it is not part of the new SSIS (2012).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 10:26am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics