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

x
?
Solved

SSIS PACKAGES

Posted on 2012-04-02
2
Medium Priority
?
472 Views
Last Modified: 2012-04-03
Hi

I have a development warehouse database and staging database refered to as db1. The databases is loaded with SSIS PACKAGES refered to as ssis 1.

I have created another warehouse database and staging database of the same schema refered to as db2. I did not want to re write the packages ssis1 so i coped them from the project folder and pasted them in a new folder. i then created a new projected  ssis2 and added the existing packages using the wizard. The problem i am having is when i amend the connections in ssis2 to point database db2 it updates the original packages (ssis 1) as well as ssis2!

is this a bug in ssis or am i doing something wrong, what is the correct way of repointing the connections?
0
Comment
Question by:ac_davis2002
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 37799471
You've probably forgotten to update one or two connection managers.  The best method to ensure your connections are going to the right database is by using Package Configuration.  Using that method will centralize your configuration items, such as connection strings, and will make it easier to use the same packages on several different environments (DEV, INT, PRD).

Let's try to get you started.  There are five different types of configuration.  The ones you'll encounter most are XML Config file, SQL Server table and Environment variable.  Try experimenting a bit with this.  For instance, try configuring a test package using XML Config file to get a connection manager to point to another DB.  Use a simple Execute SQL statement to write something to a test table.  Then check your DB if the test record ended up in the right database.

More info:
http://msdn.microsoft.com/en-us/library/cc895212.aspx
http://msdn.microsoft.com/en-us/library/ms141682(v=sql.105).aspx
0
 

Author Closing Comment

by:ac_davis2002
ID: 37800170
Thank you
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

873 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