the invalid character for cast specification problem we had only seemed to be on Datetime columns.

first thing we did is remove the data conversion steps in some of the...

Hi Tim,

I hope Microsoft can help too. We were also thinking about opening a case, but the problem is random and haven't been able to reproduce it.

Grts,

P

Hi there, We have been having the same problem with ssis on sql Server 2005 64 bit version. Sometimes it fails with an invalid cast specification on a datetimefield. When...