Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Using SSIS to Maintain the File System Expand / Collapse
Author
Message
Posted Thursday, February 23, 2012 11:47 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:13 PM
Points: 17,940, Visits: 15,929
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1257126
Posted Friday, February 24, 2012 1:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:25 PM
Points: 13,511, Visits: 11,300
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
Posted Friday, February 24, 2012 5:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 12, 2014 8:13 PM
Points: 5, Visits: 259
Could you post the Script Task code in C# please.
Post #1257342
Posted Friday, February 24, 2012 6:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 3:23 PM
Points: 116, Visits: 55
Good grief! Talk about using a sledgehammer to drive a tack.
Post #1257378
Posted Friday, February 24, 2012 7:51 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:13 PM
Points: 17,940, Visits: 15,929
Koen Verbeeck (2/24/2012)
Great article, thanks.


Thanks Koen




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1257422
Posted Friday, February 24, 2012 7:52 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:13 PM
Points: 17,940, Visits: 15,929
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.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1257424
Posted Friday, February 24, 2012 7:55 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:13 PM
Points: 17,940, Visits: 15,929
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.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1257427
Posted Friday, February 24, 2012 8:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 3:23 PM
Points: 116, Visits: 55
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
Posted Friday, February 24, 2012 9:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 4, 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
Posted Friday, February 24, 2012 10:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:06 PM
Points: 138, Visits: 455
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse