Delete files from different folders, approach plz

Question

Delete files from different folders, approach plz

kishoremania

Ten Centuries

Points: 1059
More actions
August 17, 2012 at 2:28 pm

#280365

Hi
I have a requirement that I need to implement delete logic before loading into it. I have around 10 excel files need to be loaded, each in different folder. Before that I need to delete those files from folders.
Can someone please tell me the logic in ssis.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

n79799 SSC Eights! Points: 804 More actions · Answer 1

this should help......

If there are 10 different files each in different folder, I would suggest a script task with a C# script to delete a file and error out and fail the package(or howsoever you wan to design)

on error.

The other way could be :

Create a variable for path of folder....say src_path

Bring all your folders as resultset of a sql query....like

select 'c:\folder1' union select 'c:\folder2' union select 'c:\folder3'

Load it into a recordset destination(say the var rs)

Set Up a foreach Loop Container. Drive the iteration based on the rows contained in the recordset variable(look up help on ForeachLoop Container). Map the collection value on each iteration to the variable called src_path.

Set up a File System Task inside the loop container. Set The 'Operation' as 'Delete File'.

Drive the Source connection through a variable src_path

This way, upon completion of the loop, all your fiels ahould be deleted.

Hope this helps.

kishoremania Ten Centuries Points: 1059 More actions · Answer 2

Thanks for your reply.

Can you please be in detail, how to lookup the recordset variable from foreachloop container.

kishoremania Ten Centuries Points: 1059 More actions · Answer 3

kishoremania

Ten Centuries

Points: 1059

August 29, 2012 at 12:02 pm

#1531550

Can anyone please look into it

Phil Parkin SSC Guru Points: 246686 More actions · Answer 4

kishoremania (8/29/2012)
Can anyone please look into it

Not until you prove that you have tried. There are plenty of resources available on the Internet for this fairly straightforward task. Come back and post again if you have specific questions. People here won't do your work for you - we're unpaid volunteers.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Phil Parkin SSC Guru Points: 246686 More actions · Answer 5

I suggest that you search for something like "shredding a recordset in ssis".

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.