[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSIS

Posted on 2012-04-13
4
Medium Priority
?
253 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 668 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 664 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 668 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

834 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