Well, I re-ordered the SCD select statement and saved/closed/re-opened and it all seems to work properly now with the DBTIMESTAMP.

just one other of those things where you have to have...

I have a similar issue, so I created a table called dbo.DataSources

Create a column for Environemnt (PROD or DEV)

and a column for server, schema and tables. You may need some...

Try this, works great:

MSSQL2008:

http://sqlblogcasts.com/files/folders/transforms/entry11865.aspx

MSSQL older:

http://sqlblogcasts.com/files/3/transforms/entry2.aspx