get a list of files in dts

[splitthird]

I need to get a list of xls files in a folder and then read data from each of them in DTS.

As a first stage I'm trying to find out if it is possible to run a DOS command in DTS? The command would do "dir *.xls /b > file.txt"

I would then need to read the values from the text files to find the names of the xls files and go on from there.....

thanks in advance for any help

 

[yksvaan]

Yes, it's Execute Process Task. But making a loop in DTS is a burden, it is not obvious how to do it, workflow precedence is not enough. But it is possible (dun it), there's a example of activex needed in SQL documentation(bol).

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[jhall01]

I tend to use an ActiveX loop and the FileSystemObject to loop through files in a folder.

check out

http://www.sqldts.com/default.aspx?246