Once again my friend Nitesh has all the answers....

Nitesh has the perfect answer, nothing else required. Though another way could be that you donot do the above, instead use a derived column transform in the data flow task to replace quotes and then send the output to table....

Few comments from my side: **Alpesh**: As I have mentioned you are not supposed to use Script Task. Try some other way!! **Guenter**: How do you get the file names in a sorted order using Flat file connection? Secondly will your Script component n...

A folder has a lot of files dumped in and each file has an ID suffixed with timestamp followed by any other value. Now the challenge is to get one copy of file per day based on the unique ID. In case there are multiple files for...