Chris,

Thanks. Those are very helpful pointers on what works and does not work. And thanks for the reference to Moden's article. I should've included some DDL for...

Yes! That works as desired. Thank You!

Are there other ways though, for evaluating it?

--something like:

IF isnull(@OrderNumRtrn, 0) = 0 OR @OrderNumRtrn = '000000'

...

Doh! Didn't see all the subsequent posts already answering. Sorry.

No. This can be also done in SSIS 2005 & 2008. SFTP missing . . .that seems like an issue for anyone running a business.

? What is a use for this? Just getting the date for use at another time? If you try to convert the value back to...