none
SSIS Project Deployment-Connection manager Username, passwords changing in Every ETL run RRS feed

  • Question

  • Hi,


    SSIS Package Connection manager credentials are changing on every  month, these credentials needs to taken from the Secret Server Pass code Server, what ever the username and pass code generated in secret server those values needs to update in connection manager in SSIS Packages. Present SSIS packages are in project deployment mode with Environment variables for connection managers . In the SSIS Project we have 15 packages and 10 Project connection managers, all are individual packages no parent child packages.

    Please suggest me the way needs to fulfill this requirement.

    I am planning to create one package in the same project with script Task to get credentials from secret pass code server, but Connection managers are in Project mode so it is allowing parameters only not variables, we can not mention Project parameters in script task to store output value.I Struck on this point.




    Thursday, December 12, 2019 5:49 PM

All replies

  • Hi RavitejaMaybe,

    >> "...Present SSIS packages are in project deployment mode with Environment variables for connection managers..."

    There is no need to change anything. You just need to update SSIS Environment values in the SSISDB programmatically.

    Thursday, December 12, 2019 7:04 PM
  • You mean that before Execution of present package i need to update Environment variable values in SSISDB.
    Friday, December 13, 2019 2:33 AM
  • Please share the SSISDB table details related to Environment variable, so that table i will update and test in lower environments
    Friday, December 13, 2019 2:35 AM
  • Hi RavitejaMaybe,

    We can do as the following steps:

    1.Configure a project connection manager with a project parameter
    2.Deploy the project to the catalog
    3.Create an environment in the SSIS catalog, along with a variable
    4.Link the environment to the project and the variable with the parameter
    5.Execute a package using the environment

    Please refer to Setup Environment Variables in SQL Server Integration Services.

    Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, December 13, 2019 6:49 AM
  • You mean that before Execution of present package i need to update Environment variable values in SSISDB.
    Friday, December 13, 2019 6:21 PM
  • Hi RavitejaMaybe,

    Yes.

    May I know if you have anything to update?

    Please remember to click "Mark as Answer" the responses that resolved your issue. 

    This can be beneficial to other community members reading this thread.

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, December 16, 2019 9:04 AM