Post reply

Can SSIS logging use the Reporting Services Database or SSISDB Database?

  • October 20, 2014 at 11:20 am

    #397536

    Hi,

    We don's have any user databases for SQL server. We have system databases like Reporting services database that has the catalog table etc for our sharepoint integrated mode configuration. We have SSIS catalog database SSISDB. Can I use one of these databases to store my SSIS package logging?

    Or is there a recommended place to store the SSIS logging table other than any user database?

    Thank you,

    Veena

  • October 20, 2014 at 12:42 pm

    #1753601

    With SSIS package logging you mean the logging you define yourself in the package?

    Personally I would store these in a seperate database, not in the SSRS database or the SSIS catalog.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 21, 2014 at 10:56 am

    #1753828

    Thank you Koen,

    With SSIS package logging, I mean the sysssislog system table. We dont have any user databases in SQL server. We use sql server only for ssrs, ssis and ssas. I have seen that sysssislog table is usually stored in user databases. But is it okay to store it elsewhere?

    Thanks,

    Veena

  • October 21, 2014 at 12:20 pm

    #1753841

    venus.pvr (10/21/2014)

    Thank you Koen,

    With SSIS package logging, I mean the sysssislog system table. We dont have any user databases in SQL server. We use sql server only for ssrs, ssis and ssas. I have seen that sysssislog table is usually stored in user databases. But is it okay to store it elsewhere?

    Thanks,

    Veena

    Normally that shouldn't be a problem.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply