We are trying to import data from a source application that uses a timestamp datatype (SQL Server 2000) column in each table to indicate that the record/row has been changed. When we import the tables in Designer the timestamp columns are not imported in. How can we make them visible so that we can include those columns in the import from the source applications? (fyi: the source application is a purchased application so we have no control over that schema)
The second part of this problem is that we have created a binary(8) column (SQL Server 2005) on the corresponding target tables to receive the timestamp column’s value. Just as the import did not shoiw the timestamp column, it also did not include the binary column.
Any suggestions?
fyi: I did the import using SSIS, as an experiment, with no problem. Just trying to find a way to do this in BODI.
rsherman (BOB member since 2008-05-21)