?
Solved

SSIS PACKAGES

Posted on 2012-04-02
2
Medium Priority
?
468 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
[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
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

765 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