Variables are extremely important and are widely used in an SSIS package. In this article, I will show you how to use variables in your SSIS package. I also showed you how to add a Data Flow task that contains the components necessary to extract data from a SQL Server database, transform the data, and load it into an Excel spreadsheet. In previous articles in the SSIS Basics series, I showed you how to set up a SQL Server Integration Services (SSIS) package. SSIS Basics: Introducing Variables - Simple Talk
