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…
Controlling the execution sequence of tasks. I’ll begin by dragging these tasks unto the designer: Execute SQL, Data Flow, and Send Mail. Then, connect the Execute SQL task’s green arrow to the Data Flow task. Right-click the new constraint and verify these values. Drag new constraints between the Execute SQL task, Send Mail task, and…
Sharing custom variables between tasks in a package. In this example, I’ll illustrate the use of a package-level variable being shared between ForEach Loop Container and Script Task Control Flow tasks. This package will iterate through text files and display the name of each to the user. As I explained in my Overview of Variables…
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…
Implementing conditional logic to redirect output. 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, it’s imperative to ensure…
Performing complex, iterative actions. In this example, I’ll illustrate how integrate iterative actions into a package. 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 and naming it Filename. Next,…
Using a For Loop and Script Task objects to monitor the file system. In this example, I’ll illustrate how to use a For Loop container to wrap a Scrip Task object which iteratively monitors the file system for the presence of a file and once found, uses another Script Task object to notify the user.…
Using custom C# code to iterative through files. In this example, I’ll illustrate how to integrate custom iterative actions into a package. 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…
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…
TechMbaBi 