Solved

SSIS PACKAGES

Posted on 2012-04-02
2
463 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 500 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now