Using SSIS to Maintain the File System

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jason Brimhall » Using SSIS to Maintain the File System

21 posts, Page 1 of 3

1 2 3 »»»

Using SSIS to Maintain the File System

Rate Topic

Display Mode

Topic Options

Author

Message

SQLRNNR

Posted Thursday, February 23, 2012 11:47 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Comments posted to this topic are about the item Using SSIS to Maintain the File System

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1257126

Koen Verbeeck

Posted Friday, February 24, 2012 1:03 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

Great article, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1257176

Rob Sonders

Posted Friday, February 24, 2012 5:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 5:19 PM
Points: 4, Visits: 202

Could you post the Script Task code in C# please.

Post #1257342

mark.hammond

Posted Friday, February 24, 2012 6:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 7:20 AM
Points: 113, Visits: 52

Good grief! Talk about using a sledgehammer to drive a tack.

Post #1257378

SQLRNNR

Posted Friday, February 24, 2012 7:51 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Koen Verbeeck (2/24/2012)

Great article, thanks.

Thanks Koen

Post #1257422

SQLRNNR

Posted Friday, February 24, 2012 7:52 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Rob Sonders (2/24/2012)

Could you post the Script Task code in C# please.

If somebody out there knows how to do that, they are welcome to post it. I don't have that code.

Post #1257424

SQLRNNR

Posted Friday, February 24, 2012 7:55 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

mark.hammond (2/24/2012)

Good grief! Talk about using a sledgehammer to drive a tack.

You're welcome to post your more simple elegant solution. As was stated in the onset of the article, there are many ways to perform this task. Many people try to use maintenance plans to perform file cleanup on the OS. Unfortunately, those fail more often than not. Also, that option is also built on SSIS as well.

Post #1257427

mark.hammond

Posted Friday, February 24, 2012 8:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 7:20 AM
Points: 113, Visits: 52

My point is why use a database process to act on a file system. Let the database system do what it is intended to do and, likewise, let the file system do what it is intended to do.

You can probably use SSIS to trigger FTP processes. The question is WHY would you do that.

I CAN run across the freeway at rush hour. Just because I CAN doesn't mean I SHOULD.

Post #1257436

tmcc

Posted Friday, February 24, 2012 9:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 04, 2013 11:57 AM
Points: 3, Visits: 68

Good example of using SSIS to manage files. For those that using logging to the file system for package runs.. this type of program will help clean up.

Post #1257512

Mad Myche

Posted Friday, February 24, 2012 10:53 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 07, 2013 7:35 AM
Points: 135, Visits: 416

I was kinda disappointed when I realized that this was not going to be an article on Denali's filestream methods.

Director of Transmogrification Services

Post #1257553

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions