Hi all,

I have a SQL Server 2000 DTS that ends with an execute process task; it
works fine when run from the designer in Enterprise Manager, but not from SQL
Server Agent.

I have set the instance of SQL Server to run under a domain account with
network access and local administrator rights. The Agent is configured with
the same account. However, I don't think it's an account related problem as
the SQL Server tasks work perfectly from the SQL Server Agent job.

The Win32 process is C:\Program Files\MapInfo\Professional\MAPINFOW.EXE and
the parameter is "D:\GIS\GIS1\WIP\MAB\MapBasic\QV Rates Update - SQL
Server.MBX"

I've looked at the information in the Microsoft KB
(http://support.microsoft.com/?kbid=269074) but I had already set the
suggested options.


Many thanks,

Did u use ActiveX Script in Transformation's Workflow Properties?
That's happened to me too cause I use ActiveX in Workflow Prop. After I
remove it, it works.

No, the DTS is simple SQL commands plus the execute proccess task. My current
thinking is the proccess I'm invoking is not a true 32-bit application.

"Resant" wrote: