Yes it works!!! thanks a ton guys!!

Ohh thats great!

I am uploading another file which has more data. Can you please try this one? Please let me know if this one works fine for you as...

Many thanks for your reply.

As mentioned earlier, I am loading the data from an excel using a SSIS package. I use a SQL task to load the data. Below is...

Hi David,

Thanks a lot for your suggestion.

I have been able to figure out how to use the File System Task to rename a file. This link helped me a lot...