Solved

SSIS PACKAGES

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.

726 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