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 |
|
BaconPopper
Starting Member
7 Posts |
 Posted - 2010-09-23 : 11:33:32
|
| Hi,I have a simple package which read from SQL Server and loads into a flatfile.The OLE DB source connection uses SQL authetication.I set up package configurations with XML to store the credentials of the OLE DB connection.The value for the password is empty the first time, but when I put the password in the config file, my package runs without any problem.If I do the same but store the configuration info in a SQL table (which is stored in the same DB as the one i'm going to read the data from), my package won't work stating that he can't login.If I check the config table, everything is set-up correctly though (including the password)Anyone who know's a solution for this problem?grts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-09-23 : 13:40:47
|
| whats the protection level set for the package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
BaconPopper
Starting Member
7 Posts |
Posted - 2010-09-24 : 03:43:07
|
| It's set to DonSaveSensitive, as it is supposed to be. |
|
|
|
BaconPopper
Starting Member
7 Posts |
Posted - 2010-09-28 : 04:55:06
|
| nobody who had the same problem before?or does everybody uses integrated security when deploying solutions at clients? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-28 : 13:52:26
|
| i always use rely on server storage and roles |
|
|
|
BaconPopper
Starting Member
7 Posts |
Posted - 2010-09-29 : 04:14:03
|
| that doesn't work at all when using configurations |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-29 : 09:23:47
|
| sure it does. how are you executing the package? as part of a sql agent job? this is just a permissions problem |
|
|
|
BaconPopper
Starting Member
7 Posts |
Posted - 2010-09-29 : 10:06:20
|
just in BIDS to test itgot the following error:quote:
TITLE: Microsoft Visual StudioFailed to apply package protection with error 0xC0014061 "The protection level, ServerStorage, cannot be used when saving to this destination. The system could not verify that the destination supports secure storage capability.". This error occurs when saving to Xml.
and i don't even use an XML file.Solved my problem though by using indirect configuration and storing my main config connection string in an environment variable |
|
|
|
|
|
|
Package configuration error & SQL authentication