all groups > sql server dts > july 2003 >
You're in the

sql server dts

group:

Calling DTS Package from ASP



Calling DTS Package from ASP Paul Kavanagh
7/14/2003 10:04:17 AM
sql server dts: 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,

Re: Calling DTS Package from ASP Paul Kavanagh
7/14/2003 8:43:26 PM
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


[quoted text, click to view]
Re: Calling DTS Package from ASP Allan Mitchell
7/14/2003 11:24:40 PM
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



[quoted text, click to view]

Re: Calling DTS Package from ASP Allan Mitchell
7/15/2003 7:05:30 AM
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



[quoted text, click to view]

Calling DTS Package from ASP Adrian
7/22/2003 4:15:37 AM
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 exactly:object DTS.Package -
server.createObject failed - invalid progID
Best regards,
Adrian

[quoted text, click to view]
AddThis Social Bookmark Button