You would Add groupings.   Can you provide a schema of the database?

Good points about the auditing and class diagrams thanks.  Unfortunately some of the leaders are saying the dev and design groups are too busy to work much on providing documentation...

Thank you Jeff and Grant for your input!

Yes my conceptual model doc will layout keys, uniqueness, relationships, and attribute rules and constraints.  Eventually.

I think one question I had is.... Is...

No the database does not exist.  I have a conceptual design doc where i have defined several entities based on the UI designs i have seen.  I will be elaborating...

Actually I saw there is another error before this (but I didn't see it because it was listed near the bottom of the log).

Error: The SSIS Runtime has failed to...

DB,

your procedure fails because it is expecting a table variable.  You need to implement dynamic sql to pass table names.

create or alter procedure test_output @tbl_name varchar(50), @num_rows int = 0...