Overview
Data flow destination, providing easier to use alternative of the standard OLE DB Command transformation for amending table records.
Setup
The script has the following parameters:
- ConnectionType - selects connection type: ADO.NET or OLEDB.
- Connection - selects connection.
- Table - selects destination table.
- QuoteCharacters - selects symbols to be used as quotation mark delimiting identifiers.
- Action - selects component action for destination table:
- Insert - insert data.
- InsertUpdate - insert data. If insert fails, use update.
- UpdateInsert - update data. If update fails, use insert.
- Update - update data.
- Delete - delete data.
- PrimaryKeys - selects destination table primary key columns.
- IdentityColumns - selects table identity (auto increment) columns. Optional.
- InsertedVariable - selects variable to store number of rows inserted. Optional.
- UpdatedVariable - selects variable to store number of rows updated. Optional.
- DeletedVariable - selects variable to store number of rows deleted. Optional.
- ErrorRowDisposition - selects how to handle errors in input rows:
- IgnoreFailure - errors are ignored.
- RedirectRow - errors are redirected to error output.
- FailComponent - errors cause component to fail.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Table_Update_Destination.jsKnowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.