question

RiteshDEV01 avatar image
RiteshDEV01 asked

SSIS: Copy latest and largest file only to another folder

I have to copy a file to different folder from the below files. Source Folder: **C:\Expense** Destination Folder: **C:\Expense_Details** - MonthENd_Expense_01.DAT_C5_20150731 16 mb - MonthENd_Expense_01_CRR.DAT_C5_20150731 1 kb - MonthENd_Expense_01_ERR.DAT_C5_20150731 1 kb Each month sets of files comes to 'Expense' folder. Source folder has previous month files also. **Tasks I have to do** - - Only latest and largest files should be copied. (**MonthENd_Expense_01.DAT_C5_20150731**) not other 2 files and no older files. **Problem I'm facing:** These files' dates in extension itself and every month these extension will be change to different dates. I have to do this in SSIS. **Note: This is not a duplicate question.**
ssissql-server-2008-r2file-system
10 |1200

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

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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