Author

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: https://social.msdn.microsoft.com/Forums/security/en-US/8fb47c45-f1d9-4eaa-a2a1-f126ccbc1ef2/connection-manager-changes-are-not-saved-after-edit-the-package-still-retains-the-old-server-name?forum=sqlintegrationservices https://social.technet.microsoft.com/Forums/officeocs/en-US/7a9f1ea3-7dbf-4389-9856-9ad745c9e9fe/ssis-connection-manager-not-saving-changes?forum=sqlintegrationservices

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