Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlval
Starting Member
12 Posts |
 Posted - 2011-06-16 : 19:24:58
|
| I am experiencing a problem with SSIS written in VS2005. I am using Microsoft OLE DB Provider for Oracle to connect to the DB, and it works just fine if I manually run the package. Then I set up protection level to EncryptSensitiveWithUserKey and create a configuration file to save all connection information. When I execute the package with the config file, I get en error "The AcquireConnection method call to the connection manager "Oracle Connection" failed with error code 0xC0202009".Why would it happen and how should I fix it? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-17 : 07:12:17
|
| I usually create a variable to hold this sort of thing and set it in the package call.If you have the data in the config file or set the variable you can save the package without sensitive data.I would also log the data that has been set at the start of the package so you can check that it has happened properly - at least while developing.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sqlval
Starting Member
12 Posts |
Posted - 2011-06-17 : 11:27:46
|
| When you create a variable and then save it in config file, does it mean the password can be read by anyone who has access to the file? I would like to avoid this situation. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-17 : 11:45:21
|
| I would save it in a table (encrypted if you wish or just protected) and use that in the package execute.I don't tend to use config files with v2008.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
sqlval
Starting Member
12 Posts |
Posted - 2011-06-17 : 12:15:16
|
| Should it be a table within another database? |
|
|
|
|
|
|
Cannot save Oracle connection in the config file