摘要：This is avery short post containing a useful code snippet for writing to a SQL Server Integration Services (SSIS) variable from within a script task. Imports Microsoft.SqlServer.Dts.Runtime Public... 阅读全文

摘要：Counting Rows in SQL Server Integration Services I am often asked if there is a way to capture row counts in SSIS. For example, a user may want to know how many rows passed along certain outputs o... 阅读全文

摘要：The Microsoft Data Warehousing Strategy A Platform for Improved Decision-Making through Easier Data Access and Analysis July 11, 1998 Microsoft Corporation Contents Introduction The Data Warehousing P... 阅读全文

摘要：Transforming OLTP Data to OLAP Data Warehouses The transformation of OLTP data so that it gives acceptable performance in an OLAP system requires these processes: Merge Data You must be able to mer... 阅读全文