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 |
|
vmurali
Yak Posting Veteran
88 Posts |
 Posted - 2007-06-27 : 04:34:07
|
| When I am trying to run my package from C# code. i am getting the error Failed to acquire connection <connection name> (0xC00291EC ).Does anyone know how do solve this issue. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-27 : 04:48:54
|
| Probably either the user that you are running it under or the machine it is running on.What's the connection - does it need anything set up - e.g. a dsn, tsn, ...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vmurali
Yak Posting Veteran
88 Posts |
Posted - 2007-06-27 : 05:09:40
|
| Presently I am having 2 ADO.net connections in my SSIS package. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-27 : 05:35:16
|
| I set connections from variables and log those variables at the begining of the package (and other points) so that I can see what is happening.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Failed to get connection error