Home Forums SQL Server 2005 SQL Server 2005 Integration Services convert datatype using derived column transformation RE: convert datatype using derived column transformation
hodgy
SSCertifiable
Points: 5795
More actions
August 14, 2008 at 6:52 am
#858005
You can do it in the derived column transformation using the syntax (DT_I4)[Your Column] in the expression field (for a four-byte signed integer).
Life: it twists and turns like a twisty turny thing