I have a Folder full OF CSV Files, that have File Names LIke this PropertName-4-18.csv with the last art of the file name as the date. I am needing to import all this into SQL Database with SSIS. The Data in the files is all numeric ad formated like this.
... And So on.
I am trying to figure al this out, and know i am going to need to do a for each loop. but I am needing the Data when it is Imported to look like this:
So i need touse the date from either the file name or date the actual file was created. Please advise. There are literally hundreds of file so i don't want to have to process each one individually.