Sql Server Integration Services

IncludeInDebugDump

2012-10-16T08:32:00.000-07:00

Indicate whether the variable value is included in the debug dump files.
For user-defined variables and system variables, the default value for the InclueInDebugDump option is true.
However, for user-defined variables, the system resets the IncludeInDebugDump option to false when the following conditions are met:

    If the EvaluateAsExpression variable property is set to true, the system resets the IncludeInDebugDump option to false.
    To include the text of the expression as the variable value in the debug dump files, set the IncludeInDebugDump option to true.
    If the variable data type is changed to a string, the system resets the IncludeInDebugDump option to false.

When the system resets the IncludeInDebugDump option to false, this might override the value selected by the user.

Conditional Split Transformation

2012-10-16T08:27:00.004-07:00

Conditional Split Transformation=The Conditional Split transformation can route data rows to different outputs depending on the content of the data. The implementation of the Conditional Split transformation is similar to a CASE decision structure in a programming language. The transformation evaluates expressions, and based on the results, directs the data row to the specified output. This transformation also provides a default output, so that if a row matches no expression it is directed to the default output.

split and join transformation

2012-10-16T08:27:00.001-07:00

The following transformations distribute rows to different outputs, create copies of the transformation inputs, join multiple inputs into one output, and perform lookup operations.

Fuzzy Grouping Transformation

2012-10-16T08:16:00.003-07:00

Fuzzy Grouping Transformation
The Fuzzy Grouping transformation performs data cleaning tasks by identifying rows of data that are likely to be duplicates and selecting a canonical row of data to use in standardizing the data.

Aggregate Transformation

2012-10-12T10:45:00.001-07:00

Aggregate

Calculates aggregations such as SUM, COUNT, AVG, MIN and MAX based on the values of a given numeric column. This transformation produces additional output records.

Adding aggregated information to your output. This can be useful for adding totals and sub-totals to your output.

Data Mining Query Task

2012-10-11T15:02:00.003-07:00

Data Mining Query Task:
This task will run a DMX (Data Mining Extensions) query that create a prediction based on new data that is run against a Analysis Services data mining model.

Analysis Services Processing Task

2012-10-11T15:02:00.001-07:00

Analysis Services Processing Task: This task will process Analysis Services Cubes, Dimensions, and Mining Models.

Analysis Services Execute DDL Task

2012-10-11T15:01:00.003-07:00

Analysis Services Execute DDL Task: This task will run data definition language statements on Analysis Services. This allows for the create, drop, alter of cubes, dimensions and mining models.

Transfer SQL Server Objects Task

2012-10-11T15:01:00.001-07:00

Transfer SQL Server Objects Task: This task will transfer a single or multiple SQL Server database objects between SQL Server instances. Most of SQL Servers DDL objects can be copied with this task.

Transfer Master Stored Procedures Task

2012-10-11T15:00:00.002-07:00

Transfer Master Stored Procedures Task: This task will transfer a single or multiple SQL Server Master database stored procedures between SQL Server instances.

Transfer Logins Task

2012-10-11T14:59:00.006-07:00

Transfer Logins Task: This task will transfer a single or multiple SQL Server logins between SQL Server instances.

Transfer Jobs Task

2012-10-11T14:59:00.003-07:00

Transfer Jobs Task: This task will transfer a single or multiple SQL Server Agent jobs between SQL Server instances.

Transfer Error Messages Task

2012-10-11T14:59:00.001-07:00

Transfer Error Messages Task: This task will transfer a single or multiple SQL Server user defined error messages between SQL Server instances. It can be setup to transfer specific user messages or all error messages.

Transfer Database Task

2012-10-11T14:58:00.005-07:00

Transfer Database Task: This task will copy or move a SQL Server database between two instances of SQL Server. It can even be used to make a copy of a database on the same server. Databases can be copied either online or offline.

Execute SQL Task

2012-10-11T14:58:00.003-07:00

Execute SQL Task: This task allows the execution of a SQL statement. If the statement returns results, they can be stored in a variable.

Bulk Insert Task

2012-10-11T14:58:00.000-07:00

Bulk Insert Task: This task offers an efficient way to copy large volumes of data.

Update Statistics Task

2012-10-11T14:54:00.008-07:00

Update Statistics Task: This task will update the statistics for one of many tables in one or many databases.

Shrink Database Task

2012-10-11T14:54:00.005-07:00

Shrink Database Task: This task will shrink the size of the SQL Server database data and database log files.

Reorganize Index Task

2012-10-11T14:54:00.002-07:00

Reorganize Index Task: This task will reorganize an index or indexes on one or many databases.

Rebuild Index Task

2012-10-11T14:53:00.004-07:00

Rebuild Index Task: This task will rebuild an index or indexes on one or many databases.

Notify Operator Task

2012-10-11T14:53:00.002-07:00

Notify Operator Task:
This task allows SSIS to notify SQL Server Agent operators. They can be notifies by email, pager, or netsend.

History Cleanup Task

2012-10-11T14:52:00.006-07:00

History Cleanup Task:
This task allows for the cleanup of historical activity data. It will cleanup the history for database maintenance plans, backup activites, restore activities and SQL Server agent jobs.
Maintenance Cleanup Task: This task allows for the cleanup of backup files, and the reports of maintenance plans

Execute SQL Server Agent Job Task

2012-10-11T14:52:00.003-07:00

Execute SQL Server Agent Job Task:
This task allows for the execution of a SQL Server Agent job.
Execute T-SQL Statement Task: This task is similar to the Execute SQL Task, however it only supports Transact SQL Statements. It should be used for SQL Server specific SQL statements.

Back Up Database Task

2012-10-11T14:52:00.000-07:00

Back Up Database Task:
This task will allow you to backup a one or many SQL Server databases.
Check Database Integrity Task: This task will allow you to check the integrity of all the objects in one or many SQL Server databases.

WMI Event Watcher Task

2012-10-11T14:51:00.003-07:00

WMI Event Watcher Task:
This task watches for WMI events that have occurred on a computer system, and allows the package to take an action if certain criteria are met.