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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Executing ssis pkg security issues

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 error
SSIS 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

   

- Advertisement -