SQL Server Migration related package

Question

We had SQL Server upgraded from 2000 to 2008.

The packages were configured using Environment variables and package configurations to point to SQL Server 2000.

Now when I change the Server name in package configuration to point to SQL Server 2008, the SSIS package is just hanging in running state. No action is being shown in the DFT.

What extra changes do I need to do in the package ?

Please help

Answer 1

Hi no_prakash,

Have you enabled Logging in your package and see what happen when the package is hanging, steps about Adding and Configuring Logging in SSIS package, please see: http://msdn.microsoft.com/en-us/library/ms167456.aspx

For more information about implementing logging in Packages, please refer to: http://msdn.microsoft.com/en-us/library/ms138020.aspx

Thanks,
Eileen

Answer 2

Check if the provider is correct SQLNCLI10.1 - check the connection string.

Data Source=<Server>;Initial Catalog=<DB>;Provider=SQLNCLI10.1;Integrated Security=SSPI;