I have a couple of SSIS packages that copy the content of several tables to another db. One of the columns updated in the process is a
timestamp datatype. From what I read this datatype can't be updated, it gets updated automatically with each
INSERT. But digging on the net I've found this and this about issues on SSIS when updating this type of column and using
DT_WSTR types. If I got it right, using SSIS packages those columns can be modified.
My issue is that now I want to replace those SSIS packages with stored procedures that will be called by the SQL Server Agent. I'm reusing the already existing code on the packages but of course I'm getting the errors "Cannot insert an explicit value into a timestamp column." or "Cannot update a timestamp column.".
Is there any way I can replicate the timestamp values from one database to the other? Without changing the table structure or column type as the whole process is already configured and running on several databases.