I need to import numerous excel documents into SQL server.
I have managed to populate a table with all the file locations and have created a DTS package for the import.
What i would like to do is loop through this table updating the global variable each time with the file location thus importing all the excel files.
Any pointers most appreciated. (Not used DTS that much!)