Easiest method if you're on 2000 - assign XLS name to a global variable. Use
Dynamic properties task to assign that name to the connection.
You should be able to read the filenames from the table into a Recordset
Global Variable and loop through that with some activex code to get the
values.
Check out www.sqldts.com for the samples on looping to get some more details.
-Pete
Ben <ben_1_ AT hotmail DOT com> wrote:
Quote:
I am tring to import multiple xls files into a sql table. I have am able to
get the file names using a file system object, but what i would like to do,
is once i have the file name, change the name of the excel connection object
to that name and then perform the data transformation. once this is done,
repeat with the next file name until complete.
can someone please help me with this task?
thanks
Ben
|
Import Question -
08-04-2005
, 10:11 AM
Linear Mode
