Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Integration Services (SSIS), SQL Server 2008 R2 Rss

   Items 1 to 6 of 6   
 

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.  Read more...
By Additional Articles 2011/08/15 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,688 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 | 2,636 reads

Implementing Execution Log Reports on 32-bit SQL Server 2008 R2

This article covers how to implement the SQL Server 2008 Execution Log DB and package on SQL Server 2008 R2  Read more...
Rating: |  Discuss |   Briefcase | 4,265 reads

Configure Windows Firewall for SQL Server 2008 Integration Services in Windows Server 2008 R2

I have installed SQL Server 2008 on Windows Server 2008 R2 and I am unable to connect to SQL Server 2008 Integration Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Integration Services in Windows Firewall for user connectivity.  Read more...
By Additional Articles 2010/06/21 | Source: MSSQLTips.com | Category: firewall
Rating:  Rate this |   Briefcase | 2,538 reads

How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2

when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as a data source in SSRS 2008 R2.   Read more...
Rating:  Rate this |   Briefcase | 2,588 reads

Introducing SQL Server 2008 and 2008 R2 Integration Services

The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.  Read more...
By Additional Articles 2010/02/09 | Source: Database Journal | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,986 reads
   Items 1 to 6 of 6   
 
Tags
sql server 2008 (2)    
administration (1)    
analysis services (ssas) (1)    
firewall (1)    
reporting services (ssrs) (1)    
security (1)