Wrox Programmer Forums
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 8th, 2006, 04:08 PM
Registered User
Join Date: Mar 2006
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.

Similar Threads
Thread Thread Starter Forum Replies Last Post
open connection in another connection adityamadisetty SQL Server 2000 1 May 4th, 2006 04:56 AM
Establish Com link to Webpage Mantis Pro VB 6 3 April 18th, 2005 04:14 AM
How to establish a sql server desktop engine pramos.21d SQL Server 2000 0 March 2nd, 2005 09:50 AM
Trying to establish an ID variable tkdk88 Dreamweaver (all versions) 3 January 25th, 2004 07:31 AM

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