Importing Excel File using DTS

[sexydog]

hi

I currently have a DTS package to import an excel file.This works fine.My problem now is that i have to read multiple excel files from one directory into the same table and i am required to read only certain columns. How can i create a DTS package that reads in files from a directory and inserts the data into the table. Each excel file has a different name but they all have the same columns...


Thanks
DJ

The early bird always catches the worm....My advice...be a late worm

 

[tb]

This question is better suited in forum961 ...

What do you use exactly in your package ... ??

Not knowing what you have ... this is my suggestion..

* create a global variable for the particular path
* create an active x script
* use Filesystemobject within the script to read the folder
and get the files
* for each file in the folder you'll do the following ...
* change the file name (data source) of the connection
* change the file name (source object) of the task
* execute the particular task

This is my way of controlling what I do ... there might be more simplified versions of this ...




I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!