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

  • 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. However, your comment

    "Remember that the password is not saved to the configuration...You have to go to the configuration and replace ***** with the actual password"

    Was an eye-opener. In all the reading and googling I had done to this point, I never saw that simple requirement.