Extract the data from csv file based on the today's date

[techipa]

Hi All,

I need to use the DTS to extract the data from CSV file to SQL table. The CSV files are upoloaded to the directory on daliy basis. I need to import the data only from one file where the date in the file name is today's date.
The naming convention of the CSV file is (Daily_02-10-07).

For example if I run the DTS today it should check for the '02-21-07' substring after 'Daily_' in the names of files under the directory, if finds then extract the data else come out of DTS.

Can any one tell me how to proceed to implement this in DTS?

Thanks in advance

-techiPA

 

[mrdenny]

Use a dynamic properties task to change the filename of the connection object.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com