SSIS Toolset and Work Environment
SSIS developers will need certain additional tools installed on their devices to execute/install SSIS via routine SQL Server install.
SQL Server Data Tools (SSDT) is one such tool that is a lighter version of Microsoft Visual Studio and is mostly encountered while creating or testing SSIS packages. As you setup your SSIS development environment, it is vital to have the SSDT version of Visual Studio installed. SSDT utilizes the logic of multiple document interface (MDI) to open/close packages individually, open multiple ones, and use them as required.
Yet another addition to the toolset is SQL Server Management Studio (SSMS). It is widely used for testing deploying ETL processes that are created in the SSIS cycle. It may not be needed while creating the packages but at a later stage, it is an essential toolset.
SSIS Work Environment
There are certain important components for the SSIS work environment. Here is a glimpse of those:
· SSIS Toolbox
Contains available operational tools for either control flow or data flow
· Properties Window
Showcases the properties of the selected component
· SSIS Package
Shows the exact package being currently used
· Solution Explorer
Simple browsing of existing solutions and all files within
· Connection Manager
Shows the existing active connections
SSIS Integration Task List
The different tasks that can be configured in the control flow are:
· Analysis Services Processing Task (Processing of one or more objects at a time)
· Send Mail Task – Sending emails with results of package workflows
· XML Task – Working with XML files and merging multiple sources into a unified one
· Execute Package/Process Task (Execution of a package from another package or breaking down of complex packages)
· Execute SQL Task (Executing SQL statements from a package)
· Data Flow Task (ETL of data from disparate source with cleaning and modification of data)
· FTP Task (uploading/downloading of files with FTP)
Comments
Post a Comment