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, March 01, 2012 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 19, 2013 2:16 AM
Points: 2, Visits: 55
mark.hammond (2/29/2012)Forgive me. I thought SSIS (SQL Server Integration Services) would be dependent on SQL Server. Maybe you know of some way to make it operate independently.

SSIS is not dependent on the SQL Server database engine. Just install it on another server.

mark.hammond (2/29/2012)
To my point, though - this solution imposes the constraint of the availability of SQL Server to perform tasks that have no inherent reliance on the existence, much less the availability, of SQL Server.

Do you prefer to maintain scheduled jobs on 345 different servers or one job server that executes the jobs for all of them? Of course there may exist many cases where it is not smart to use SSIS for these jobs, but there are also numerous situations where it is the best solution.
Post #1260070
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse