ssis - SQL Server Integration Services - Incremental data load hash comparison -
Using SQL Server Integration Services (SSIS) to load mounting data, a hash of per-imported and existing row Compare information. I am using this:
To create a SHA512 hash to compare when the data hash hash and the current hash is conditional split function (expression is NEW_HASH == OLD_HASH) When I try to compare the data import hash and compare, I get the following error when entering the expression:
The data type "DT_BYTES" can not be used with the binary operator "= = "One or both kinds of endands for operation Rthit not. To perform this operation, one or both of the operators need to be explicitly cast with a cast operator.
An equivalence error has occurred before attempting to cut each string one string (DT_WSTR, 64).
Is there a better way to do this, or do I miss some small detail?
thanks
Have you tried to increase the length of 64? I believe that DT_BYTES is valid for 8000 characters. I have legal cast destinations for the following DT_BYTES based on the following:
- DT_I4
- DT_UI4
- DT_I8
- DT_UI8
- DT_STR
- DT_WSTR
- DT_
- DT_IMAGE
I also conducted a trial in BIDS and verified that there was no problem in comparing prices when I put them in sufficiently long data type.
Comments
Post a Comment