View Single Post
  #1 (permalink)  
Old March 8th, 2006, 04:08 PM
mungdrool mungdrool is offline
Registered User
Join Date: Mar 2006
Location: Cincinnati, OH, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Reply With Quote