SQL Server Integration Services
Please see my other Business Intelligence articles. SSIS is Microsoft’s ETL platform which was designed to migrate and manipulate data in support of the Business Intelligence (BI) lifecycle (SQL Server, SSIS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). For more information, please read SSIS: An Overview. SQL Server Integration Services (SSIS) An…
Business Intelligence (BI) encompasses leveraging descriptive and inferential statistical analysis upon massive organizational data stores to enable strategic decision-making. SQL Server Integration Services (SSIS) SQL Server Integration Services (SSIS) is the most-used tool for Extract-Transform-Load (ETL) operations inherent within BI solutions. SQL Server Reporting Services (SSRS) SQL Server Reporting Services (SSRS) represents the most popular reporting platform,…
Using Views to generate source data 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…
Combining records from different data sources. 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 to ensure the…
Reading data from text files. 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 the…
Creating an SSIS Package to consume a table and write the recordset into a text file. Rename package to match project Next, Create data source allowing access to sql table. create connection manager. Next, select the source database. Create a data flow task and give it a name indicating its purpose. Double-click the task to edit…
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…
TechMbaBi 