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

  • 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.

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