Saving ODBC Password in SSIS Package
-
When I try to save a password for an ODBC connection it will test ok but it won’t save it.
Any Ideas?
-
SSIS does not save ODBC passwords because they would have to be saved as plain text. You need to use package configurations. Interestingly, if you create a package configuration for the password for a connection manager, SSIS does not save the password in the config file either, you have to open the file and enter the password yourself.
Another option is to use a variable and an expression.
-
It still doesn't work even when I make a config file (See Attach)
-
That should work. Are you getting messages about the application of the config file (or an error about it) in the feedback window when you open the package?
-
Within the Visual Studio 2019 SSIS Server project, I can test the connection successfully:
But then, when trying to run I get:
[Connection manager "HANA.C153_USER"] Error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
Progress: 2022-10-27 13:30:05.27
Source: Data Flow Task
Validating: 0% complete
End Progress
Log:
Name: OnPipelinePreComponentCall
Computer: MMOBTINB01
Operator: AzureAD\HermannRosch
Source Name: Data Flow Task
Source GUID: {38A191F2-DA4C-418D-8037-AF499961438D}
Execution GUID: {B5267753-FEF9-40CD-B301-BB87AA4B4312}
Message: Data flow engine will call a component method. : 2 : ODBC Source : AcquireConnections
Start Time: 2022-10-27 13:30:05
End Time: 2022-10-27 13:30:05
End Log
Error: 2022-10-27 13:30:05.28
Code: 0xC0014009
Source: Package Connection manager "HANA.C153_USER"
Description: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.
End Error
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply