It occasionally works to change the output on your source. The safest means to ensure it is the proper type though is to use a derived column transform like Jack mentioned.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events