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 i run the package again after it has failed it will work fine on the same data.

Is there a data conversion step in the package that fails?

We also have another weird problem which a data flow at one of our customers. This one doesn't fail. it just inserts empty ('') rows. The data flow has a sourcestep, which is based on a query. The query selects 6 hard coded rows. Select 'a' as code, 'the first letter' as description union select 'b' etc..

The package does not fail but eventhough hard coded just 6 blank rows are added to the table. We only notice because the database grows for a table that joins on the code field and when empty it gets multiplied by 6.

It seems to me sql server 64 bit has some ssis issues. I find many posts with the same problem.. That is the problem of the cast specification and not finding the solution.

Have you found a solution or a workaround?

Greetings,

P