Post reply

getting the environment variables for a 2012 ssis solution

  • September 9, 2015 at 9:52 am

    #320293

    Hi, please only answer if you actually know the answer.

    Is it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?

    Thanks B

  • September 10, 2015 at 12:39 am

    #1825596

    Barkstuff (9/9/2015)

    Hi, please only answer if you actually know the answer.

    Is it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?

    Thanks B

    This article could help: SSIS 2012 Projects: Deployment Configurations and Monitoring[/url]

    😎

  • September 10, 2015 at 12:45 am

    #1825602

    When you create the environment variables, you have the option to script them out. Sadly this only works when you create them, not afterwards.

    You could extract the values out of the catalog using T-SQL and the catalog views, or you could use PowerShell.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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