sql server dts: DtsPipelineException Invalid Class String -- sql server dts

DtsPipelineException Invalid Class String

mystical potato
10/30/2007 9:51:03 AM

sql server dts:

I'm trying to run an SSIS package via a web service on my sql server. The
following code is generating error DtsPipelineException -2147221005 "Invalid
class String".

I can't seem to find anything searching for this error. What I'm doing is
pretty straight forward. Does anyone have any thoughts?

'------------------------------------------------------------------------
Dim ssis As New Application
Dim strPkgPath As String = "myPackage"
If ssis.ExistsOnSqlServer(strPkgPath, "myServer", "myUser", "myPassword") Then
'...do something
Else
throw Error...

RE: DtsPipelineException Invalid Class String

mystical potato
10/31/2007 4:33:02 AM

I also noticed that from Mgt Studio if I right click and select Import
Package when I click on Package Path I get the same Invalid Class String
error. This happens from my local machine on any of my sql 05 servers but it
works if I remote into the server.

Any clues?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.