Gary,

Do you have to use Active X?

I've written packages where I'll list all the files in a particular directory and then process them one at a time. I do this all from an SP that runs the import package. I manually run the SP so I haven't needed to put it in a DTS package/Job yet.

Step 1 - List all files in directory and insert them into a log table.

Step 2 - Then I read each file path name and process each file by executing the dtsrun command.

Step 3- Move files to appropriate archive directory

Okay just realized your post was almost a year old... Nvm.