Post reply

How to add database source name and database destination name dynamically on a SSIS?

  • April 29, 2013 at 3:33 am

    #271884

    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?

  • April 29, 2013 at 11:34 am

    #1610930

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply