SSIS comparing Binary columns using Conditional Split

I need to compare two varbinary columns using SSIS Conditional Split component.

I cannot use the == 开发者_JAVA技巧operator with varbinary.

What is the best way to compare two varbinary columns.

Have tried converting to TEXT datatype but this gives me various problems.

Two Columns are compared in Script Transformation Component , But do not know how to columns with Binary DataTypes are compared.

If anybody answers how binary values can be compared in Scrit component..you will have ur answer.

Could you use a Script Component, and compare the varbinary columns using VB.NET or C#? You could then assign a value to a new column in the data flow that lets you identify if they were identical. The Conditional Split could then use the new column as the condition.