SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Data Warehousing, SQL Server 2005 Rss

   Items 1 to 3 of 3   

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,791 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,538 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,071 reads
   Items 1 to 3 of 3