Data flow destination, used to verify that an upstream component produces a particular output. The expected data is specified in a CSV-like format without the need to use an external file. The first row contains the column names and each row of data is separated with newline.
The script automatically converts input values to string values (
null values are converted to
"null" string). If any differences are encountered the script fails and displays the details, including the first difference and the entire expected and actual datasets.
The script has the following parameters:
- Data - specifies expected test data.
- ColumnDelimiter - specifies column delimiter. Optional.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.