Solved

SSIS

Posted on 2012-04-13
4
247 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

732 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