SQL Server Integration Services
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…
Creating a new Excel spreadsheet at runtime and writing data into it. 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…
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…
Transforming data into new fields. This example will demonstrate the three primary components of a data flow: data source, data pipeline, and data destination. First, drag an OLE DB source unto the designer. Configure the data source by configuring a new connection manager and the correct database and table. For this example, I will only…
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…
TechMbaBi 