Well, because SSIS sees it as a varchar.

But I found a solution for me as well for SQL2k0, SQL2k5 and SQL2k8.

So this topic can be closed 🙂

The issue here is that I get an parameter filled with quotes. This isn't accepted by SQL Server when executing the stored procedure. So I can't validate on the timestamp...

It's not a datetime format, but a timestamp format:

this is an example how it works when I get the data for my sp.

exec sp_example '9929129', '0x0000000001E5CFE7'

where the hex is my...