Monthly Archives: September 2014

Using variables in SSIS – Simple example

Using variables in SSIS – Simple example Working with variables in SSIS: A simple demonstration Before building the ETL package we need create a sales history table: CREATE TABLE Product_Sales_History( SaleID BIGINT NOT NULL UNIQUE, ProductID VARCHAR(50) NOT NULL, Total … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , | Leave a comment