jeudi 12 avril 2012 08:42
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 ?
- Type modifié no_prakash jeudi 12 avril 2012 09:08
Toutes les réponses
lundi 16 avril 2012 06:39Modérateur
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
lundi 16 avril 2012 07:28
Check if the provider is correct SQLNCLI10.1 - check the connection string.
Data Source=<Server>;Initial Catalog=<DB>;Provider=SQLNCLI10.1;Integrated Security=SSPI;