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.