I ran into the login failed for user "username" again. This time it was different from what I had faced the first time around.
My package uses config file to get the sql credentials. When I have the package open in my IDE and add another parameter to the file it wipes out the previously saved password. So now when I try to execute the package from my IDE to test the changes, I get this dB login failure message.
What threw me off was I was looking at the connection defined in the package designer and all seemed well.
So if this happens again, you need to take a look again in the config file to check if the password value is still there.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment