Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to add database source name and database destination name dynamically on a SSIS? Expand / Collapse
Author
Message
Posted Monday, April 29, 2013 3:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 13, 2014 4:10 AM
Points: 2,296, Visits: 1,424
I have a SSIS that should be execute since the server and invoke since a client. The SSIS copies the data from the source database to the client destination database, but the user wants to change the database name or server name, so how can I change the package in SSIS?
Post #1447419
Posted Monday, April 29, 2013 11:34 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 7,070, Visits: 12,523
Open the package in BIDS, change the Connection Managers to point to the new server and database and then save it back to the original location where it is referred to for execution.

If you want to make this a little easier in the future implement a Package Configuration that would allow you to change where the Connection Managers are pointing without having to modify the SSIS Package itself. You can find information about "SSIS Package Configurations" in SQL Server Books Online.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1447673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse