Post reply

Run same packege on different SQL server 2005.

  • August 6, 2007 at 1:53 pm

    #118072

    Hello,

    I am building a package with SISS.

    This package run on  SQL server 2005.

    In the near future, this package will run on diffrent server and may be also the database should change.

    How can I do to avoid evertime to change Data source and database name to the package?

    I mean, I would like to have this package is independent from SQL server and Database name?

    Thank

  • August 6, 2007 at 2:24 pm

    #724937

    Start by reading about configuration files in BOL.  You can also learn more in the WROX book Professional SQL Server 2005 Integration Services by Brian Knight, et al.

  • August 6, 2007 at 2:45 pm

    #724943

    thank

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

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