delete files using ssis

Question

delete files using ssis

Viewing 6 posts - 16 through 20 (of 20 total)

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

Phil Parkin SSC Guru Points: 246956 More actions · Answer 1

Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.

Script Tasks are used in the Control Flow (and are probably what is needed here).

Script Components are used only in data flows.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Here is an alternative article you can follow if you would like a different way of doing it with SSIS

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/87652/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Phil Parkin (7/30/2013)
Please note that Script Tasks and Script Components are different things. Using the terms interchangeably will confuse people who know the difference.
Script Tasks are used in the Control Flow (and are probably what is needed here).
Script Components are used only in data flows.

Phil, thanks for reminding me how long I've been away from SSIS. :crying:

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

rs80 SSCrazy Points: 2312 More actions · Answer 4

I ended up using Alvin's recommendation and write c# code in the script task.

Vidhyaraaghav Newbie Points: 1 More actions · Answer 5

use powershell command in execute process task

dir D:\Backup\*.* |? {$_.LastWriteTime -lt (get-date).AddDays(-2)} | del

Jeff Moden SSC Guru Points: 1004309 More actions · Answer 6

Vidhyaraaghav wrote:

use powershell command in execute process task
dir D:\Backup\*.* |? {$_.LastWriteTime -lt (get-date).AddDays(-2)} | del

Haven't tried it but looks great... Welcome aboard!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)