The first table is the Staging table used to extract the data in the exact form as it is on the source system. The GDTXFT field is the field...

It is a package software so I am sure the vendor has not updated the data types in quite some time. So I am working with what i was...

I had a problem with the script generating the drop statements for my clustered and nonclustered indexs that are not Primary Keys.

The following statement would not return the object id...

After thinking about this and trying different things this is the path I am going down. When the Companies are loaded, instead of cascading into the Plant parameter that...