Home Forums Data Warehousing Integration Services SSIS Environments and Project Parameters Conversion from 2008 Configs RE: SSIS Environments and Project Parameters Conversion from 2008 Configs<!-- 864 -->

  • Thanks for the response Phil.

    I am starting to see some benefits and after we get rolling I'm sure we'll find new and clever ways to use the environments.

    Also I answered yes to all 3 questions.

    The explanation on how the params stay linked even which switching environments was very helpful.

    What concerns me is development. We do all development on separate computers using different instances of SQL Server for each developer and we utilize our own local paths for storing source files and such.

    With the previous Package Configurations they would be applied when the package was being opened in BIDS so when I opened something on MY computer all the values would be pointing to my local resources because I setup these values in my local SQL Server configuration tables.

    Now with SSDT if I start a project then another developer opens it they will need to manually change the parameters in the package so they can work against their own dev environment. Do you know of any way around this like some sort of local environment that is built in to SSDT? Of course we could all coordinate how we store things locally and always use (local) for SQL connections.