Hope this is the right forum to post in. I am calling a
DTS package from asp. On test server, it worked fine. On
production server, we are getting an error on creating the
object DTS.Package - server.createObject failed - invalid
progID.

Inable to find this exact issue in the KB or on the web.
Not sure if the object is simply not registered on the web
server (in which case, how do we go about installing it),
or if this is a permissions problem.

Any insight would be greatly apprecicated.

Regards,

Paul

Have you registered the DTS dlls ?

Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Paul Kavanagh" <paulkavanagh (AT) nospam (DOT) tipinteractive.com> wrote

That sounds like it will do the trick. Are these dll's
included in any other redist packages, like MDAC?

Thanks for the help.

Paul

No they are not included with MDAC. When installing them make sure you
install them in the location they would have been stored had you installed
the full SQL Server product (You will need to create directories)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Paul Kavanagh" <paulkavanagh (AT) nospam_tipinteractive (DOT) com> wrote

Dear Paul,
normally this error appears when a .dll is not installed
on the server. A silly question: is the SQL Server
installed on the Production server, and if yes are you
having the same version installed?
For more information you can look on a search engine like
www.google.com and type exactlybject DTS.Package -
server.createObject failed - invalid progID
Best regards,
Adrian