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 |
|
pwvailla
Starting Member
31 Posts |
 Posted - 2011-01-03 : 11:18:03
|
| Hi, I am trying to do a basic extract and load process from an Oracle database into SQL Server 2005. I can do so via the import wizard, but when I write the SSIS data out to the file system, it no longer contains the password and thus fails. This is the SOURCE Connection OLEDB:Data Source=corp68;User ID=cost;Provider=MSDAORA.1;Persist Security Info=True;WHERE DO I SUPPLY THE PASSWORD? I want to execute this as a file and let them run unattended rather than manually via the IMPORt Wizard.Thanks |
|
|
pwvailla
Starting Member
31 Posts |
Posted - 2011-01-03 : 11:24:51
|
| I get this error: failed with error code 0xC0202009. Seems sql forums are littered with this problem but I have found no solution! |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-03 : 12:39:43
|
Open the package in BIDS, and store the login credentials there...use "encrypt all with password" or "encrypt sensitive with user key" for protection level. You can rebuild the package with the passwords stored and saved. If you are the only one running it, use the "user key" protection, that way you won't have to supply a password when using the exec utiliy.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
Use of password in SSIS packages in file system