February 4, 2004 at 10:28 am
Hello All,
I am intergrating FedEx shipping api into my site and have reached the point where I am submitting data to the FedEx servers. I would like ot run this process in the background. I am thinking to have a trigger on a order receive table that will run a DTS which will run either an EXE or DLL for this process.
Does this sound possible? If so, I am looking for some examples/documentation on how I can accomplish this.
Many Thanks
ZAID
February 4, 2004 at 12:36 pm
I do not think you want a trigger to spawn a DTS triggers are part of the transaction and the DTS make take some time, which would slow down the system. Instead, use the trigger to drop data into some table and have the DTS check this table to see what it needs to grab from FedEx.
February 4, 2004 at 12:40 pm
What will cause the DTS to execute and check the table?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply