April 29, 2015 at 7:50 am
Hi All,
I have a SSIS package in which i will download the files through FTP from main server to my local server.
the file names will be like as follows,
''EYE0001_20150428_0805_INV.TXT''
''EYE0001_20150428_0805_SL.TXT''
''EYE0001_20150428_0805_SV.TXT''
''EYE0002_20150428_0805_INV.TXT''
''EYE0002_20150428_0805_SL.TXT''
''EYE0002_20150428_0805_SV.TXT''
After the download is over from the server to my local server.i will manually rename the files into
like this as below,
''EYE0001_20150429_0805_INV.TXT''
''EYE0001_20150429_0805_SL.TXT''
''EYE0001_20150429_0805_SV.TXT''
''EYE0002_20150429_0805_INV.TXT''
''EYE0002_20150429_0805_SL.TXT''
''EYE0002_20150429_0805_SV.TXT''
SO i need to automate this files renaming process through ssis package.
can anyone please help me out .
I am waiting for your replies.
April 29, 2015 at 12:46 pm
Use a File System task.
April 29, 2015 at 12:48 pm
use an SSIS variable and use an expression in the variable to set the value to hold the name concatenating the date part you are wanting. Then use that in the file system task with the rename setting.
April 29, 2015 at 12:51 pm
Go here for more descriptive explanation: http://www.bidn.com/blogs/KeithHyer/bidn-blog/2465/copy-and-rename-a-file-in-ssis-using-the-file-system-task
May 4, 2015 at 1:57 am
THis Link is not working .
May 4, 2015 at 1:30 pm
I just copied and pasted it into my browser and it worked. You can also google "SSIS File System Task Rename File" and get a slew of returns.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply