Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Connection Manager Change Breaks Package

Author  Topic 

Analyzer
Posting Yak Master

115 Posts

Posted - 2012-10-09 : 11:31:57
Given sqlmaint package off the web to test. Connect Managers require replacing causing a string of problems parts of the package used GUIDS.

Changed all areas to use 'Connection Manager' names not GUIDS but still getting 'Error at login with IsDisabled Diff' and other messages. Is there a more simple method to change the connection definitions through the package. E.g can you open package a .XML file or something and Ctl H, change values?

Thanks in advance


visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-09 : 22:56:50
you need to use package configurations for that

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -