p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 (http://p2p.wrox.com/forumdisplay.php?f=242)
-   -   LoadFromSqlServer - Can't establish connection (http://p2p.wrox.com/showthread.php?t=39549)

mungdrool March 8th, 2006 04:08 PM

LoadFromSqlServer - Can't establish connection
This may be a stupid question, but do you need to have the SSIS service running in order to use the LoadFromSqlServer method? I have SQLExpress installed on my machine and am trying to code an application to load a package, modify some parameters, then execute it. I don't have the SSIS service on my machine as it does not come with the SQLExpress version of the product. However, I would expect a different message if that was the problem. I have even tried changing the server name in my call to a known server with the service and get the same error. It seems like I have a connection issue rather than a service issue but I don't know how to debug it.

The message I receive is:
method has encountered OLE DB error code 0x80004005(Client unable to establish connection).

The call I make is
p = app.LoadFromSqlServer(pkgName, "jtendam-d\sqlexpress", Nothing, Nothing, Nothing)
where pkgName is a string containing the package I want to load and "jtendam-d\sqlexpress" is the name of my machine and the instance of SS installed on it.

Thanks for any help.

All times are GMT -4. The time now is 08:49 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.