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

Content with tags Data Warehousing, Integration Services (SSIS) Rss

   Items 1 to 5 of 5   
 

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 3,712 reads

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,883 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,398 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,447 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,055 reads
   Items 1 to 5 of 5   
 
Tags
sql server 2005 (3)    
design and theory (1)    
etl (1)    
extract, transform, load (etl) (1)    
miscellaneous (1)    
partitioning (1)