0

How can the sysssislog table to show up in a user database's system tables? This is for SQL server 2012.

4
  • The sysssislog table is located in the system database [msdb] under System Tables. Are you asking how can you get the data into a table in a user database?
    – samosql
    Commented Feb 19, 2018 at 18:05
  • Kind of. Actually I see sysssislog table in the user database in the system tables portion of the database in my development environment. I need to do the same in prod envt.
    – user145098
    Commented Feb 19, 2018 at 18:09
  • By default, sysssislog table only exists under System Table for the System databases [msdb]. If you are seeing sysssislog in a user database, then you must have a package that is setup for execution logging and it creates the table in the specified database if it does not exist.
    – samosql
    Commented Feb 19, 2018 at 18:14
  • 1
    That makes a lot of sense, thanks for the reply.
    – user145098
    Commented Feb 19, 2018 at 18:32

1 Answer 1

3

By default, sysssislog table only exists under System Table for the System databases [msdb]. If you are seeing sysssislog in a user database, then you must have a package that is setup for execution logging and it creates the table in the specified database if it does not exist.

Not the answer you're looking for? Browse other questions tagged or ask your own question.