I need to get data from multiple text files based on the name of the text file, into a table in SQL Server 2000. I have written a DTL package that can get data from one text file where the text files name is hard coded as the Source. The text file names are as follows: Log_20090923.txt, Log_20090924.txt - one for every day of the week. I need to get at least 30 days of the text files into the table. How can I do this? Can you give me an example please?
Thanks a lot!