Home Forums Data Warehousing Integration Services Problem with SSIS Package Configurations and SQL Server Authentication RE: Problem with SSIS Package Configurations and SQL Server Authentication

  • December 9, 2013 at 1:27 pm

    #1672119

    Gerald.Britton 28181 (12/9/2013)

    Koen Verbeeck (12/9/2013)

    Step 7 is normal. Once you open the connection editor, the password is removed.

    Which configuration did you use in step 10? Remember that the password is not saved to the configuration (if it would, it would be really use to hack that connection). You have to go to the configuration and replace ***** with the actual password.

    Which config? The one I set up for my test.

    Allo me to rephrase: which type of config? XML, SQL Server config table?

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