SSIS Logging: Write to File
Execute as “Script Task”.
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
Working with Quotes In String
Replace quotes in string. Generating quotes in string. Ex: label.setObjectText(“Barcode1”, “1008800400002”); Display quotes string in razor.
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