SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Administration, Integration Services (SSIS) Rss

   Items 1 to 4 of 4   

Collect Data from Multiple Instances Using SSIS and Powershell

Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.  Read more...
By S. Kusen 2015/02/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,490 reads

SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task

Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.  Read more...
By Additional Articles 2011/04/07 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,139 reads

Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.  Read more...
By Additional Articles 2010/04/28 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 2,936 reads

Speeding up the VS/SQL User Interface Load Time

A frustrating thing for those who open and close Query Analyzer all day long about the new Visual Studio interface for SQL Server is the load speed. This quick blog shows you how to speed up the load time with a switch change.   Read more...
By Brian Knight 2005/12/22 | Source: White Knight Technology | Category: administration
Rating:  Rate this |   Briefcase | 3,750 reads
   Items 1 to 4 of 4   
automation (1)    
data flow (1)    
data gathering (1)    
development (1)    
error log (1)    
powershell (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)