SSIS Package Data Manager "Not a valid account name or password"

Lou Rosk 0 Reputation points
2023-07-30T14:30:49.1566667+00:00

I have an SSIS Project (version 16.0) that I am developing in Visual Studio 2019. In one of the packages I have a package level Excel Connection Manager. It works fine when I run it. If I try to add the my user credentials (My user name as it appears in the system variable @[System::UserName] and password) I get the error "Not a valid account name or password"

I am confused because I thought that if I don't specify a UserName and Password that it uses my credentials. If I add those same credentials manually it gives me an error. I need to be able to specify credentials so I can deploy it.

Project Security ProtectionLevel is set to EncryptSensitiveWithPassword

Package Security ProtectionLevel is set to EncryptSensitiveWithPassword

Please help me figure out how to use manually entered credentials with the Connection Manager.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2023-07-31T02:18:41.7166667+00:00

    Hi @Lou Rosk

    Please try to set DelayValidation to true in Connection Manager property.

    By doing that you could skip the pre-validation.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.