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), ETL Rss

<< Newer    Items 21 to 29 of 29   
 

We Loaded 1TB in 30 Minutes with SSIS, and So Can You

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don't have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.  Read more...
By Additional Articles 2013/01/25 (first published: 2010/01/19) | Source: Microsoft MSDN | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 8,812 reads

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,248 reads

Data Cleansing with the SSIS Data Flow

A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...
By Press Release 2009/10/21 (first published: 2009/10/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,215 reads

Data Cleansing with the SSIS Data Flow

A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...
By Press Release 2009/10/21 (first published: 2009/10/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,215 reads

Data Cleansing with the SSIS Data Flow

A webinar from MVP Brian Knight and Pragmatic Works this week will help you learn how to clean up data and apply business rules in your data flows.  Read more...
By Press Release 2009/10/21 (first published: 2009/10/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,215 reads

Using SSIS to Capture the File Name

This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.  Read more...
Rating: |  Discuss |   Briefcase | 14,708 reads

Eliminating Empty Output Files in SSIS

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...  Read more...
By Tim Mitchell 2009/10/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,906 reads

Creating Dynamic Outputs in SSIS

In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.  Read more...
Rating: |  Discuss |   Briefcase | 9,903 reads

Flat File Imports with SQL Server Integration Services 2008

A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.  Read more...
Rating:  Rate this |   Briefcase | 4,293 reads
<< Newer    Items 21 to 29 of 29   
 
Tags
blogs (2)    
business intelligence (2)    
performance tuning (2)    
sql server (2)    
stairway series (2)    
architecture (1)    
bi (1)    
bulk insert (1)    
conditional split (1)    
configuration (1)    
data cleansing (1)    
data pump task (1)    
data warehouse (1)    
data warehousing (1)    
database mail system (1)    
delimiters (1)    
error logging (1)    
event handler (1)    
excel (1)    
fact table (1)    
flat file connection (1)    
for each task (1)    
html (1)    
incremental load (1)    
md5 hash (1)    
parsing column data (1)    
partitioning (1)    
scd (1)    
script component (1)    
scripting (1)    
setup (1)    
star schema (1)    
string manipulation (1)    
transformation (1)    
truncation (1)    
t-sql (1)    
user-defined functions (1)    
webinar (1)