 |
The Expression Component avoids the requirement to have to write opaque VSTA code to execute even the simplest bit of logic, enabling simple expressions relating to tasks such as incrementing a variable or formatting a date to be written easily. Expressions can reference variables, columns and .Net Framework code, and the result can be stored in a column or variable. |
 |
The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL. This component addresses some of the major usability issues with vanilla SQL Server Integration Services. |
 |
The Lookup Component allows lookup logic to be graphically defined. The existing SQL Server Integration Services component for this role is not actually bad, but there is a problem with caching dynamic data and it is effectively useless for looking up a value from a table or view thaty may actually be changed by your package. For example a typical use of a lookup component is to see if some peripheral data exists and create it if not. |
 |
The Basic Map Component allows you to define simple and flexible value mappings. |
 |
The Advanced Map Component allows you to define sophisticated data transformations graphically. |
 |
The Organize Columns Component allows you to delete, rename, re-order and filter columns within a data-flow. |
 |
The Cross Join Component allows you to merge, correlate and manipulate data from multiple sources. |
 |
The Unicode Conversion Component provides a strightforward way of mapping all string fields in a data-flow to unicode or ansi format. |
 |
The Union All Component merges data-flow outputs together, but in a dynamic way - that is the output fields are always updated automatically based on the inputs. |
 |
The Web Service Call Component allows you to easily consume web services. |
 |
The ZIP Component allows data to be compressed or decompressed. |
 |
The Certificate Component allows data to be validated or signed / encrypted based on X509 certificate security. |
 |
The OLEDB Bridge Component allows you to use a common connection for components requiring both OLEDB and ADO.Net connections. |
 |
The File Component allows you to locate, read and write files much more flexibly than under vanilla SQL Server Integration Services. |
 |
The Change Filter Component efficiently compares the entire state of a data-flow with the state at the time it was last row, breaking down all changes into inserted, updated or deleted rows that can then be routed differently. This component can also be used to compare two separate databases. The Commit Change Filter Component commits the current state of the data-flow as the reference source. |
 |
The Convert Component allows you to convert a message between EDI, Xml, HL/7, delimited, positional and binary formats. |
 |
The Simple Transaction Begin, Simple Transaction Commit and Simple Transaction Rollback components allows you to manage database transactions across individual connections without the use of DTC. |
 |
The Sleep Component provides a simple way of sleeping for a given nyumber of milliseconds, for example in a polling scenario. |
 |
The If/Then/Else and If/Then/MultiCast components provide a strightforward and intuitive way of implementing simple conditional logic. |
 |
The Log Variables Component allows you to dump the current state of the package variables to the Windows event log. |