May 6, 2014 at 12:32 am
Iam able to move a file in SSIS File System task but for renaming ,should I need to add another step or?
destination path is static but destination file name is dynamic
May 6, 2014 at 12:38 am
For moving and renaming at the same time, you can use the Rename option of the File System Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 6, 2014 at 12:50 am
how to use rename option ,my new name is existing file name with todays date
May 6, 2014 at 12:53 am
You choose "Rename file" from the dropdown menu?
Populate a variable with an expression that calculates the new filepath (directory + filename). Use this variable in the File System Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 6, 2014 at 1:04 am
can u pls elaborate pls? steps
May 6, 2014 at 1:08 am
Copy and rename a file in SSIS using the File System Task
In the article they use the Copy File method of the File System Task, but you can use Rename File as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 6, 2014 at 2:53 am
Thanks a lot.I acheived it
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply