I guess my main problem is that I can't seem to capture the filename to assign to the variable...I've what I mentioned above and even using a connection string in...

GSquared (1/23/2009)

---

Yes, this can be done with SSIS.

Declare a variable, set up a For...Each...Next loop that goes through the files in the folder, and assign the file name to the...

I went with 7-zip because I couldn't get find the command line executable for winzip so the evaluation screen wont pop up (I tried all .exe files in the winzip...