Thank you for your speedy answer Sudeep, I needed that inspiration. I did it similarly but to accomplish the task I had to use a whole file path and a file name variable separately mapped to two columns in the initial query which used the record set desti...

Thank you for your speedy answer Sudeep, I needed that inspiration. I did it similarly but to accomplish the task I had to use a whole file path and a file name variable separately mapped to two columns in the initial query which used the record set de...

HI Sudeep Raj, I got your post: SSIS–Dynamically set File Mask : FileSpec to work. Very nice job. I need to do something similar. And that is to pull file name paths from a database and copy all the files shown in the list into one directory. The wh...

HI Sudeep Raj, I got your post: SSIS–Dynamically set File Mask : FileSpec to work. Very nice job. I need to do something similar. And that is to pull file name paths from a database and copy all the files shown in the list into one directory. The who...