how to delete old flat file in ssis

Question

question

fantumahi2 asked Apr 17, '14

how to delete old flat file in ssis

I have old flat file from 2009 that are on my drive for long years. i want to create SSIS package to delete all of them except the last three months. i want my package to count from today and do calculate three months back and delete them all. So is there any one who can help me how am going to create the package? thank you

ssis truncate

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.

Answer 1 · 2014-04-17T13:19:32Z

JohnM answered Apr 17, '14

The easiest/quickest way is probably with a Script Task. Here are some references: http://social.msdn.microsoft.com/Forums/en-US/449edab3-ec20-4e37-a257-5e4dfce878df/delete-files-older-than-3-days-using-ssis-tasks?forum=sqlintegrationservices http://www.mssqltips.com/sqlservertip/2930/sql-server-integration-services-package-to-delete-files-from-a-network-or-local-path-based-on-date/ There might be a way to make it work with a Foreach Loop Container but I'm not sure about how to accomplish that Hope this helps!

1

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.

eaglescout commented · Apr 17, 2014 at 02:03 PM

Great idea, @JohnM @fantumahi2 you might also be able to accomplish this task in a smaller scale using "File System Task". Either Way, I'd try using @JohnM suggestion first!

1 ·

Answer 2 · 2014-05-07T18:54:32Z

fantumahi2 answered May 7, '14

Thank you .. it was helpfull

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.

Answer 3 · 2014-07-24T02:58:24Z

fantumahi2 answered Jul 24, '14

Thank you so much

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.

question