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 18, 2008 at 4:52 am
#859350
what happens if you do as Crispin suggests and carry out the conversion in the source SQL? So, choose SQL command from the drop down and cast the column to an int.
Life: it twists and turns like a twisty turny thing