SQL Server Migration related package
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
April 12th, 2012 11:42am
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
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2012 9:39am
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
April 28th, 2012 2:47am
Check if the provider is correct SQLNCLI10.1 - check the connection string.
Data Source=<Server>;Initial Catalog=<DB>;Provider=SQLNCLI10.1;Integrated Security=SSPI;
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2012 3:35am