Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Call DTS from ASP

Status
Not open for further replies.

HaveTrouble

Programmer
Jan 10, 2005
63
US
I've created a DLL that will initiate DTS, then have a ASP to call the DLL. The DLL is tested fine. However, when I run the ASP, it kept having "Invalid class string" error. What could be the problem ?
 
Mistyped CLSID, not registered .DLL (regsvr32)...

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)
[banghead]
 
DLL is registered and CLSID is correct. When I run the DLL on server, it errors out on the following line:

oPackage.LoadFromSQLServer myserver, myserverid, myserverpwd, DTSSQLStgFlag_Default, , , , MyPackage

I created this DLL from my PC and it works fine. But after I moved it up to server and run the DLL from server, that's when the "invalid class string" error occured. idea ?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top