SSIS Connection Manager Not Saving Changes

Problem: The Connection manager has been configured to be updated in Package Configuration. Solution: Go to “Control Flow” tab -> right click -> Package Configurations Set to point to new configuration file. Source:

Outer / Cross Apply

SQL Server 2005 introduced the APPLY operator. SQL Server APPLY operator has two variants; CROSS APPLY and OUTER APPLY The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the... » read more

Data Flow Task

The Data Flow task encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved. Addition of a Data Flow task to a package control flow makes it possible for the package to extract, transform, and load data. A data flow... » read more

Execute Process Task

The Execute Process task runs an application or batch file as part of a SQL Server Integration Services package workflow. Although you can use the Execute Process task to open any standard application, such as Microsoft Excel or Microsoft Word, you typically use it to run business applications or batch files that work against a... » read more

Foreach Loop Container

The Foreach Loop container defines a repeating control flow in a package. The loop implementation is similar to Foreach looping structure in programming languages. In a package, looping is enabled by using a Foreach enumerator. The Foreach Loop container repeats the control flow for each member of a specified enumerator. SQL Server Integration Services provides the following... » read more

Table Variables

Microsoft introduced table variables with SQL Server 2000 as an alternative to using temporary tables. In many cases a table variable can outperform a solution using a temporary table, although we will need to review the strengths and weaknesses. Scope Unlike the majority of the other data types in SQL Server, you cannot use a... » read more

Script Task

The Script task provides code to perform functions that are not available in the built-in tasks and transformations that SQL Server Integration Services provides. The Script task can also combine functions in one script instead of using multiple tasks and transformations. You use the Script task for work that must be done once in a... » read more