SSIS高级转换任务之渐变维度详解

复制Use AdventureWorks   GO   CREATE TABLE [dbo].[PayrollDeductItem](   [PayrollDeductItemID] [int] IDENTITY(1,高级1) NOT NULL,   [EmployeePlanIDNbr] [varchar](50) NULL,   [DeductionAmount] [money] NULL,   [EmployeeID] [int] NULL,   [PayDeductType] [char](10) NULL,   [HistTextStatus] [char](10) NULL   CONSTRAINT [DF_PDI_HistTxtStatus] DEFAULT (CURRENT),   [HistBitStatus] [bit] NULL   CONSTRAINT [DF_PDI_HistBitStatus] DEFAULT (TRUE),   [HistStartDate] [smalldatetime] NULL,   [HistEndDate] [smalldatetime] NULL,   CONSTRAINT [PK_POLICY] PRIMARY KEY CLUSTERED   (   [PayrollDeductItemID] ASC   ) ON [PRIMARY]   ) ON [PRIMARY]   GO   INSERT INTO PAYROLLDEDUCTITEM(EmployeePlanIDNbr, DEDUCTIONAMOUNT, EMPLOYEEID,   PAYDEDUCTTYPE, HISTSTARTDATE)   SELECT 000000001, 200.00, 1, 401K, 01/01/2004   UNION   SELECT ZZ0-10001, 10.00, 1, LIFE, 01/01/2004   UNION   SELECT 000000002, 220.00, 2, 401K, 01/01/2004   UNION   SELECT DC001-111, 10.00, 2, BUSPASS, 01/01/2004   UNION   SELECT 000000003, 300.00, 3, 401K, 01/01/2004   UNION   SELECT ZZ0-10003, 10.00, 3, LIFE, 01/01/2004   GO  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.67.