| Author |
Topic |
|
shantheguy
Starting Member
22 Posts |
 Posted - 2012-07-27 : 02:24:30
|
| Hi All,I have developed a package in SSIS and created a XML configuration for it.After the build i entered the Password manually into the config file. But my package is still failing with error like unable to login to the Database. Please help me out to resolve the issue.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-27 : 02:36:24
|
| hmm...are you using sql authentication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
shantheguy
Starting Member
22 Posts |
Posted - 2012-07-27 : 02:56:17
|
Yes Visakh.. using sql authentication for connecting to databasequote:
Originally posted by visakh16
hmm...are you using sql authentication?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
shantheguy
Starting Member
22 Posts |
Posted - 2012-07-27 : 03:19:17
|
| Yes first i kept it as sensitive with user key my package got failes even it has the password in the config file. then i changed it to dont save sensitive with the config file inside the package. But still its getting failed. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-27 : 10:30:59
|
| hmm..did you map password as a config item and stored it in xml file as article suggests?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
shantheguy
Starting Member
22 Posts |
Posted - 2012-07-30 : 00:23:16
|
| i gave password after the database user. but not like as it is specified. Will try that and let u know. Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-30 : 03:10:34
|
| np...you should do it through config file otherwise it will not be able to get value at runtime------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
shantheguy
Starting Member
22 Posts |
Posted - 2012-08-01 : 05:38:32
|
| I followed the steps in the link.it worked Visakh. Thanks a ton |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-01 : 09:54:03
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
SSIS Package failing with configurations