Controlling the sort order of data within the pipeline. I’ll begin with two separate text files, each representing sales from two states: California and Oregon. First, I’ll add a DataFlow task and add to it two Flat File sources each configured to pull in data from the text files. When configuring the sources, it’s imperative…

Executing the Import/Export Wizard within a package. Following the same steps to create a package in the Table to text file article, I begin with an SSIS Project and a starting package. Instead of using the default package, I’ll delete it and select to create a new package using the Import/Export Wizard. After configuring the…

Combining tasks to perform complex, iterative actions. In this example, I’ll illustrate how combine tasks by nesting one inside the other. This package will iterate through text files and display the name of each to the user. As I explained in my Overview of Variables article, I’ll begin by adding an new Package Level variable…

Integrating Custom SQL Into the Package. First, drag a Execute SQL Task unto the designer. Next, I’ll fill the “HumanResources.NewHires” table with records. In my resultset, the PK values ranges from “105” to “114.” Double-click the task, then SQL statement property’s ellipses to enter the SQL statement. In this example, I’ve chosen to empty the…

Executing SSIS Packages with a stand-alone application. This article uses the same package created in the Table To Text File article. Using Start/Run, I will execute DTExecUI.exe which allows for graphic execution of an SSIS package. Next, I configure the utility to execution a file-system package and enter its path. Then, I configure the connection…

Using DataViews to debug data entering the pipeline. I’ll begin this article using the same project to SQLServer to DataReader, export data from a table into a DataReader. When this tutorial is complete your Package should look identical to the screen shot above, with two DataView icons next to each connecting green lines between the…

Adding additional data to the output related to package execution. I’ll begin with two separate text files, each representing sales from two states: California and Oregon. First, I’ll add a DataFlow task and add add to it two Flat File sources each configured to pull in data from the text files. When configuring the sources,…

Enabling data-sharing between tasks within a package. Often when performing multiple complex tasks within a package, data created from one tasks must be accessed either for testing or further manipulation by other tasks. Variables provide the best method for providing this kind of cross-collaboration. Variables may provide system data such as those commonly used within…

Exporting SQL Server to a DataReader. In this article, I will demonstrate using SSIS to connect to SQL Server, export data from a table into a DataReader. When we’ve completed this tutorial, you should see the above screen. First, drag a DataFlow task unto the Control Flow designer. Next, double-click the DataFlow task which will…