Post reply

Global Variables for connection manager

  • October 10, 2016 at 7:17 am

    #330830

    Hi Sir,Madam,

    We are trying to implement global variables in SSIS. for example from development to UAT to production, the database details will be changed so that we need to manually change the connection strings in connection manager setting.

    Is there any chance to define all variables in properties file and the those variables can apply in connection manager settings? so it mean we just need to apply variable name in Connection manager value.

    Please ask me if you need any more info.

    Thanks in advance.

  • October 10, 2016 at 7:47 am

    #1905653

    ramireddyjava (10/10/2016)

    Hi Sir,Madam,

    We are trying to implement global variables in SSIS. for example from development to UAT to production, the database details will be changed so that we need to manually change the connection strings in connection manager setting.

    Is there any chance to define all variables in properties file and the those variables can apply in connection manager settings? so it mean we just need to apply variable name in Connection manager value.

    Please ask me if you need any more info.

    Thanks in advance.

    You can use 'environments' in SSISDB for this purpose. Have a read here[/url] for more information.

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

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