I've used the same/similar solutions in the past to delete files if they exist and replace them with a new extract file.

Try running it from the command line and see what happens.

Use just '\\ITITPAFS02\pds\voicenet\isiti\winzip\wzzip.exe \\ititpafs01\pds\inetpub\ftproot\accumen\political \at0123.zip \\ititpafs01\pds\inetpub\ftproot\accumen\political \at0123.xls'

You maybe running into rights issues crossing servers.

Absolutely.  We used winzip and command line parameters in our task.

you should be able to use @variable = functionname(parameters) or you may need to do this using a proc with the function being called in the proc.

1 connection.

Use a proc to read the systable(s) and dump the needed info into a ## temp so it can be read by the active-x, on success call the active-x.

In...

You are on the right track, and I'd give you the code if I could find it, but unfortunately I don't have access to it here at work.

Using a DTS package...

Are you looking for a return receipt type option beyond the task success/fail?

Looks like I misread your question.  George is correct.

1st, what are you trying to created (what business process) with this flag.  If you're trying to create an automated process for processing reorders then access might not be your...

Found the code for the Proc and I have a sripted DTS too if you need it.  Proc is below.  Hope this helps.

ALTER   proc dbo.usp_execute_dts @strTxtFile  as varchar(200),

                          ...

It's been a while, but i believe that you would simply call a stored proc that calls the DTS Package.  You can add two variables, you should be able to...

Try using a dts package.  Create your source as the text file, your destination as your table and map just the field(s) you need.  Get creative and make the whole...

I'd have to agree with Journeyman.

Access to education / training (including fees paid and paid time).  I'm sick and tired of having to take vacation time to attend training.  My...

Mr. Smith is correct.  The true anser to your question lies in the errors table that Access generates.  It will list line by line what the errors are.  It may...

I've done something similar in the past by using multiple record sets in the asp page and using DIV tags to hide the ones not selected.  In my case I...