question

Victor.abkin asked Aug 18, '17

How to rename external file in SSIS

I have a folder for my destination excel file called MyDest. It has let's say 3 files: Output.xls Output_062017.xls Output_072017.xls When I'm creating new file for MyDest folder it must be named Output.xls So what I need is to rename existing Output.xls to Output_082017.xls and after that put new Output.xls into that folder Please help

ssis excel

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green answered Aug 21, '17

you will need to use a file system task with the use of a variable which sets the new filename passed on an expression of the current date when the package is run. then you can create the xls file as output and carry on with the tasks in hand.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Victor.abkin answered Aug 21, '17

Thanks Anthony, I'll try that

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 answered Aug 22, '17

Also, have a look on this: https://social.msdn.microsoft.com/Forums/en-US/86ede735-d900-4a24-a264-001c6b9a2731/rename-file-in-ssis?forum=sqlintegrationservices Discussed in brief !!!!!!!!!!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Victor.abkin answered Aug 22, '17

Thanks guys, I solved it

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.