Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Integration services AcquireConnections exception

2 views
Skip to first unread message

hanan....@gmail.com

unread,
Feb 17, 2008, 9:09:36 AM2/17/08
to
Hello,

I am trying to programatically create an SQL Server destination in
SSIS. I am creating the connection string, then initiating a
connection, and then call AcquireConnections(nothing).

When running in debug mode or in command line, all works perfect.
However, when running from within a Windows Service, I get the
following exception:

System.Runtime.InteropServices.COMException (0xC020801C): Exception
from HRESULT: 0xC020801C
at
Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.AcquireConnections(Object
pTransaction)
at ...

Any ideas ?

Thanks,
Hanan.

0 new messages