Convert EDI data stored in an SQL Server database into rows of data in the same database.
Read EDI data from a set of date sorted rows and flatten it into new rows and columns.
Variables
Credentials to access the SQL Server database.
SQL Query to retrieve keys and the EDI data to process.
Parameters to use in your SQL Query, if any. Refer to slide out help for more information.
Datetime stamp where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
Datetime stamp where the processing of your sequentially sorted data should end. Leave this field blank to process all records with a datetime stamp after the starting point.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
Table where the new rows from the converted EDI data will be created.
Columns names where the parent_key, row_id, xml_path and xml_value values should be stored. Order of the names must match the order of the columns in the Target Table.
Delete existing rows in the Target Table with the same parent_key value as rows being inserted.
Number of rows from the converted EDI data to collect prior to inserting them into the Target Table.
Read EDI data from a set of integer sorted rows and flatten it into new rows and columns.
Variables
Credentials to access the SQL Server database.
SQL Query to retrieve keys and the EDI data to process.
Parameters to use in your SQL Query, if any. Refer to slide out help for more information.
Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
Table where the new rows from the converted EDI data will be created.
Columns names where the parent_key, row_id, xml_path and xml_value values should be stored. Order of the names must match the order of the columns in the Target Table.
Delete existing rows in the Target Table with the same parent_key value as rows being inserted.
Number of rows from the converted EDI data to collect prior to inserting them into the Target Table.