Thank you for your reply. As I said I am still learning and there is no specific reason for this scenario. I did not know how to extract the File Name or File Path from the Connection Manager.
As you guys suggested I will use a Script Task to get the File Path and Use it in Execute Process Task and will also try to move the File to a different location.
To Move the file to a different location I should use File System Task by specifying the operation as Move To, right?
But to do this also I need the Path to the output file(the file which I would like to move) which I should get from Connection Manager using Script Task, right?
And as Shawn Melton specified the connection string will be parameterised as of 2012+. But I have not got until there. I am still a newbie for SSIS ;-). But thank you for giving me this info.
Thanks and Regards,
Abhilash D K:-)