Script Vs. Built-In Function in SSIS
SQL Server Integration Services is a software suite that allows database administrators to transfer and use data across many database types. SSIS does this by creating an interaction layer that offers a medium to translate database data and commands across different systems. This layer involves a set of data transformations and automated tasks to make interconnectivity possible. Besides included built-in functionality, the programmer can also script tasks to perform actions not included in the stock SSIS configuration.
Other People Are Reading
-
SSIS Tasks
-
The flow of data and command transformations between servers using SSIS is controlled by the administrator through a variety of "tasks." Tasks are specific SSIS entities that contain events or operations that the administrator wishes to occur to ensure proper data transfer. Tasks can prepare the data for transfer, control how the data is translated between different databases, or make system calls to create directories or copy files on a host computer.
Built-In Tasks
-
Tasks that come complete with SSIS are called "built-in" tasks, and are available "out of the box." These tasks include the minimal processes required to accomplish data transfers, as well as specific tasks meant to ease data transfer. These include Data Flow tasks, which control data transfer from one database to another, or Bulk data transfer tasks, which automate the copying of large data sets from one computer to the next.
-
Scripting Tasks
-
Sometimes the administrator will want to accomplish an operation for which there is no task. In this case, SSIS offers a flexible task called the "Script" task. While still technically a task, the Script task allows the administrator to write code to build his own specific task. This task will work within the context of the SSIS environment, along with the other built-in tasks, but will follow the specific instructions programmed into it by the administrator.
Scripting Task Languages and Uses
-
Since SSIS is part of the Microsoft suite of software, writing code for a Scripting task involves working with the .NET framework. Specifically, programmers use the Visual Studio Tools for Applications to write scripts, which supports Visual Basic and C# programming languages. The VSTA framework must exist on the computer running the script for the script to run.
-
