Hi, I need some help to have my SSIS package do the following things. Please provide some SPECIFIC details: Â· Read the 2 files received dailyÂ· Load them into staging tables Â· Append the new data to existing table Â· Move the files from main directory to a history folder and rename the files with a date stamp on it Specifically, 1) is there a way to map columns to data using a metadata format file (like BCP), or is it best to map the columns in advance. 2) On the last item, I'd like it to (a) read a file name that looks like MyFile1.bcp.020202 (it reads it as text flat file) and be able to parse out the "MyFile1" part renaming it to a .txt. So, step one would be to check for existing file "MyFile1" --> Rename it to .txt --> Load the data --> Move file to History folder and rename it with datetime stamp. I think you can use file task, but need tech advice. Please advise on the above! Many thanks!