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), Data Warehousing Rss

   Items 1 to 4 of 4   
 

Kimball ETL Part 1 – Data Profiling via SSIS Data Flow

A new series sponsored by Actuality Business Intelligence on data warehousing. In part 1, the data flow in SSIS packages are used to profile the source data and determine how it should be handled in the process.  Read more...
Rating: |  Discuss |   Briefcase | 8,842 reads

Dynamically Generate Folders for File Output using Variables in SSIS

This article describes how to use variables in SSIS to dynamically generate folders and file placement.  Read more...
Rating: |  Discuss |   Briefcase | 10,202 reads

Generating Surrogate-Keys for Type 1 and Type 2 dimensions using SSIS

We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.   Read more...
By Harsh Bhaiya 2007/01/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,428 reads

Migrating Data Warehouse Systems to SQL Server 2005

Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.   Read more...
By Vincent Rainardi 2006/07/31 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 16,043 reads
   Items 1 to 4 of 4   
 
Tags