Solved

SSIS

Posted on 2012-04-13
4
244 Views
Last Modified: 2012-04-17
Hi I am about to create a new ssis project containing lots of packages...

the packages will point to two databases on a dev server. At a later date i want to move the packages to point to databases of the same name but on a live server...

where am i best to create the connections so i can edit them at a later date to point to different server...
0
Comment
Question by:ac_davis2002
4 Comments
 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 167 total points
ID: 37842724
there are several options you can use
read this
http://msdn.microsoft.com/en-us/library/ms141682.aspx
0
 
LVL 11

Assisted Solution

by:Simone B
Simone B earned 166 total points
ID: 37843588
We are currently using the same scenario, with large numbers of packages on test and live servers. We have found the most efficient way to do this without having to make any connection changes, is to always use localhost in the connection instead of specifying a server name. Then after testing changes to the package(s), we simply copy to production. Because our packages are deployed to the file system, no further changes are required.
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 167 total points
ID: 37846352
Hi,
You'll need to utilize the SSIS configurations, it's a dynamic configuration property for each environment you move your packages to.

currently there's multiple ways of doing it, the easiest way is using the XML file

Please check these article and decide

http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/

http://www.mssqltips.com/sqlservertip/1434/using-xml-package-configurations-with-integration-services-ssis/

http://www.mssqltips.com/sqlservertip/2459/using-a-sql-server-alias-for-ssis-package-configuration-database-connection-string/

Let me know if you need more help.
Regards,
Jason
0
 

Author Comment

by:ac_davis2002
ID: 37854882
Thanks for all your help!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question