SQL Server 2012 Integration Services - Package Variables
In the recent articles published on this forum, we have been presenting new features of SQL Server 2012 Integration Services. Our presentations have been based so far on the Release Candidate 0 (RC0) of the product, offered as a free download since mid-November 2011. Now we can take advantage of the final version incorporated into the Released to Manufacturing (RTM) bits (currently in the evaluation format, with general availability expected on April 1, 2012). While RC0 was considered to be feature-complete, the RTM build should exclude any newly discovered bugs, making your initial testing somewhat less challenging.
These product changes are also reflected by new versions of sample AdvantageWorks and AdvantageWorksDW databases, published on the CodePlex site. Download them to an arbitrarily location on your SQL Server hosting Integration Services instance (we will use for this purpose C:\Data folder), launch SQL Server Management Studio, connect to the target Database Engine, and select New->Query with Current Connection entry from the File menu. In the resulting query window, type the following in order to attach the database files and recreate their logs (as the result, both database entries should appear under Databases folder in the Object Explorer window):