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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2014-07-09 : 17:18:44
|
| I created an SSIS package using Import export utility.All it does is do a flat file load to a database table on dev.I place the package on the dev box in the specified path.First i get an error saying unable to load the xml Resolution -- I figured it was a problem with the path and resolve it.The next error i get is xp_cmdshell Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".What I do - Changed my the SSIS package protection to "don't save sensitive data"New errorSSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred Please suggest. I use SQL server authentication everywhere which i cant change.I just need to make this work. Not looking into too much security right now.Thanks |
|
|
|
|
|
Executing ssis pkg security issues