Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Monday, April 29, 2013 3:33 AM



Group: General Forum Members
Last Login: Wednesday, October 26, 2016 1:29 PM
Points: 2,523, Visits: 1,642
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



Group: General Forum Members
Last Login: Today @ 2:36 AM
Points: 7,933, Visits: 14,357
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