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 2005 Forums
 SSIS and Import/Export (2005)
 How to change my connection manager?

Author  Topic 

dewacorp.alliances

452 Posts
Posted - 2009-02-20 : 07:02:48
Hi there

I'm following up this article for deploying SSIS package that I have from dev server to production using stored as SQL: http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/

My question is how to change the detail of the connection managers that I have (sql databases)?

Thanks

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts
Posted - 2009-02-20 : 09:26:38
You will have to define yhe DataSource from a variable. And keep changing the config file (for that variable) for each environment .
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2009-02-20 : 11:39:27
nope..no need. what you need is to use package configurations. see this

http://www.sqlis.com/post/Easy-Package-Configuration.aspx
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site