FYI:

We have successfully executed this command from the DOS prompt. It just has not worked within the trigger.

Any help will be greatly appreciated,

Thanks,

Ted

our current trigger is as follows:

CREATE TRIGGER UpdateTable ON dbo.TableScan

AFTER INSERT

AS

EXEC master..xp_cmdshell 'dtsrun /S 10.0.0.0 /N Transfer /E'

When we run the DTS manually, the record is...

I need this in real time as it processes manufacturing data and will hold the build process of equipment. we have an sql 2000 server collecting data from PLC machines and...

Is there a way in SQL to use a DNS connection?

I have the trigger set to fire on insert and I want to copy that record up to the 400 for processing.