Link to home
Start Free TrialLog in
Avatar of MPKR
MPKRFlag for Germany

asked on

Executing DTS Packages fails

Hi Experts,

I want to make my users beeing able to run a DTS package from SQL Server. I tested the microsoft sample from
http://support.microsoft.com/default.aspx?scid=kb;en-us;252987 .

I get the following error:
Serverobjekt- Error 'ASP 0177 : 800401f3'
Server.CreateObject-Error

I checked google and found out that I should register the file DTSPKG.DLL beeing stored on the SQL Server using REGSRV32.EXE.

First Question: WHERE? On my IIS?? That does not work. On SQL Server? That does not help!
I found this page: http://www.asp101.com/articles/carvin/dts/default.asp and it always says that:
"DTS.Package is not installed! try Google's #1"
"DTS.Packages is not installed! try Google's #1"

Never mind if I have already registered the DLL (not even on the SQL Server registering was succesfull).

Does anyone know what to do??
Thanks MP
Avatar of peh803
peh803
Flag of United States of America image

I'm not sure I understand the question ... if you're having a SQL Server DTS Package error, it seems to indicate that you need to register the DTSPKG.DLL on your database server machine.  And you say you've done this?  

The command line text to do this would be something like this:

regsvr32 c:\dtspkg.dll

peh803
Avatar of MPKR

ASKER

No error running it on the Server. But when I try executing on ASP page!
I have read now that the Client Tools of SQL must be installed on IIS, is that right?
It doesn't seem to make sense that client tools would NEED to be installed on an IIS box; hence the ability to segregate application and database server environments.  All IIS does is use ADO to connect to your data server.  You should be able to execute everything from ASP by using the connection to your database.  

Of course, I can't say for sure if I've ever tried connecting to a non-local SQL Server environment from a server that does NOT have MSSQL client tools installed locally...Can you install the client tools on the webserver and see what happens?

peh803
Avatar of MPKR

ASKER

I'll better not. It's a productive one and I don't have a test environment. I wonder why I can't simply do it without installing anything, Data Packages are stored inside SQL server right next to tables... I would suggest there shouldn't be any problems...

I am translating the DTS package into simple SQL steps and realize it with ASP code without using DTS packages now.

Thanks for thinking!
MP
Avatar of cheehoong
cheehoong

MP,

After browsing, thru http://support.microsoft.com/default.aspx?scid=kb;en-us;252987

I think you will need to have dtspkg.dll (in the IIS box) in order to run the following line suggested in the above url.

"Set oPkg = Server.CreateObject("DTS.Package")"

Furthermore, I doubt that you will need to register the dtspkg.dll on the server where your DB is located, because it's done automatically when you are installing MS SQL Server.

The dtspkg.dll is found at the installation directory for MS SQL\80\Tools\Binn\dtspkg.dll

Normally, I would suggest you just copy over the required dll and then do a regsvr32 in the IIS box.

However, since you mentioned that, the IIS box is in production, installing MS SQL client tools maybe the best choice :)
ASKER CERTIFIED SOLUTION
Avatar of Rejojohny
Rejojohny
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MPKR

ASKER

I didn't have the time to check it out yet, but the guidoe on that page seems to know what it's talking about quite well, so I give the points to Rejoj. Thanks to all!