Hi,

I am facing similar kind of problem.I have an SSIS package which has a flat file source and an oledb destination.

I am transferring flat file content to a table.This SQL table has a column named 'SSN' defined as VARBINARY(300).Because i need to store the encrypted value in it and not the actual value.

I have created an 'Instead of Insert' Trigger on that table.So this trigger will encrypt and store the value in SSN field.

But in text file this SSN column comes as Varchar. How to type cast this varchar to varbinary in SSIS package.

I tried to convert the datatype by using Derived column,Data conversion etc.,But it did not work out.

Can anyone help me on this!

Thanks

Nisha V Krishnan