|
Home > Archive > MS SQL Data Warehousing > October 2006 > SSIS package deployment
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SSIS package deployment
|
|
|
| when I use sql server user id as the autentication for the package
connection, I receive an error "The AcquireConnection method call failed with
error code 0xC0202009" while deploying the ETL solution. But there is no
issue in deploying the packages if i change the connection to windows
autentication.
Both my source and destination servers are of sql server 2005
please let me know if anybody has faced the similar issue and found the
solution.
--
Cheers,
Srini
| |
| Nigel Rivett 2006-10-25, 6:00 am |
| How are you saving the package?
Suspect you aren't saving sensitive data (e.g. passwords).
Consider using configurations and holding the user name and password in the
configuration file - and the location of the file in an environment variable.
http://www.nigelrivett.net/DTS/ SSI...r />
ation.html
"Srini" wrote:
> when I use sql server user id as the autentication for the package
> connection, I receive an error "The AcquireConnection method call failed with
> error code 0xC0202009" while deploying the ETL solution. But there is no
> issue in deploying the packages if i change the connection to windows
> autentication.
>
> Both my source and destination servers are of sql server 2005
>
> please let me know if anybody has faced the similar issue and found the
> solution.
> --
> Cheers,
> Srini
|
|
|
|
|