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

Articles with tag ETL Rss

Search for any content tagged etl

<< Newer    Items 41 to 50 of 50   
 

Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

When you need to insert a large set of data using T-SQL, what can you do? New author Melinda Sansone brings us a best practice when using T-SQL to load data for data marts, or warehouses.  Read more...
By Mel Sansone 2009/11/23 | Source: SQLServerCentral.com | Category: data mart
Rating: |  Discuss |   Briefcase | 8,217 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,214 reads

Kimball University: Six Key Decisions for ETL Architectures

Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.  Read more...
By Additional Articles 2009/10/20 | Source: Intelligent Enterprise | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,711 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,214 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,214 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,666 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,901 reads

How to Calculate Data Warehouse Reliability

This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.  Read more...
By Additional Articles 2009/09/29 | Source: DMReview | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,955 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,891 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,291 reads
<< Newer    Items 41 to 50 of 50