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: 2 days ago @ 10:46 PM
Points: 2,296, Visits: 1,425
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 @ 4:52 PM
Points: 7,079, Visits: 12,569
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
Post #1447673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse