• Set up a configuration file for the server name. Modify each package to use the configuration file (yep, it's labor intensive for 100 packages). On the production server, put the configuration file in the path, and modify it for the proper server name. Then, just deploy your packages, and they will access the configuration file for the server name.

    Oh - IMO, it would be best to load the server name into a variable, and use that variable as an expression in all of your connections.

    What I do: I have a base SSIS package set up, that uses the configuration file, and has one standard connection. They are all set up to go - just add everything else you need to it.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2