Invalid Pseudocolumn refers to using a variable with the $ that is not one of the recognized pseudocolumns such as $rowguid, $identity or $partition.

And yes, it looks like a coding...

Yes, it's a problem. I submitted an item on Connect

https://connect.microsoft.com/SQLServer/feedback/details/398203/sp-rename-doesnt-change-the-text-of-udfs-or-procs-sp-helptext-then-returns-a-script-with-the-old-name

and it was classified as "Won't Fix"

It's something we're going to have to live with.

Regards,

Andy

Andrew Novick

SQL Server MVP

http://www.NovickSoftware.com

This is pretty well done.

I do have a suggestion for an alternative that uses only one db.

You could do the ETL into different tables instead of different databases....

There's no need to "cheat" and use the syscolumns and sysobjects tables.  While INFORMATION_SCHEMA doesn't have the information on identity columns, they OBJECTPROPERTY(<objectid>, 'TableHasIdentity') function tells you which tables have...