all groups > sql server dts > february 2004 >
You're in the

sql server dts

group:

Invalid Class String


Invalid Class String Scott Bieker
2/28/2004 7:31:05 AM
sql server dts:
We are receiving the "Invalid Class String" Exception when trying to execute our package
from a VB.Net application running on a client computer that was not used for developmen
or anything else to do with SQL/VB.Net/etc. It is a "normal" environment where our user
will running the application

Here's what we have done/built

* 10 packages using SQL 2000 sp
* Packages have a password assigned (as per one set of documentation
* Client machine has never has SQL 7 or SQL 2000 on i
* Have registered all necessary DTS Dlls
* Even ran sqlredis.exe from SQL 2000 sp3 to get latest "client" on the machin

* The packages have no issue when running from SQL Enterprise Manager or on VS.Net machine
* Client computer was upgraded to Windows XP sp1 and all other critical updates (and sqlredis/dlls were re-installed/registered

* The error is immediate...no wait...it just throws the error as soon as button is clicked

Is there some trick to making this work? What are we missing? It seems as if we have "implemented
all of the associated KB's but it is still not working

thank

Re: Invalid Class String Scott Bieker
2/28/2004 8:56:06 AM
Thanks for the tip Alan. Although we don't have any custom tasks, we were followin
the instructions in the redist.txt file. It did not say to register the custtask.dll file

However, thanks to www.sqldts.com we found a document that said to register thi
file too if our server is SQL 2000. We did this and it all works now

Kinda tricky and very particular, but it works

Re: Invalid Class String Allan Mitchell
2/28/2004 4:41:55 PM
If you are sure you've covered the version gotchas then do you have any
custom components in the packages not registered on the client?


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

AddThis Social Bookmark Button