none
How to recreate sysssislog table under System Table Folder

    Question

  • I am working in a SSIS package. I accidently drop the table sysssisLog from System Table Folder in one of my databases. How can I recreate it?

    Thanks,

    Sarah

    Thursday, July 03, 2014 9:14 PM

Answers

  • Hi Sarah,

    When you activate logging for a SSIS package and select SSIS LOG PROVIDER For SQL server,and run package.

    ssis package will create sysssislog table again as a part of logging process.

    Hope this help you.

    Regards

    If this help you please mark this as Answer 


    • Proposed as answer by pituach Thursday, July 03, 2014 10:16 PM
    • Unproposed as answer by SarahLiu Tuesday, July 08, 2014 8:27 PM
    • Marked as answer by SarahLiu Tuesday, July 08, 2014 8:27 PM
    Thursday, July 03, 2014 9:47 PM

All replies

  • Hi Sarah,

    When you activate logging for a SSIS package and select SSIS LOG PROVIDER For SQL server,and run package.

    ssis package will create sysssislog table again as a part of logging process.

    Hope this help you.

    Regards

    If this help you please mark this as Answer 


    • Proposed as answer by pituach Thursday, July 03, 2014 10:16 PM
    • Unproposed as answer by SarahLiu Tuesday, July 08, 2014 8:27 PM
    • Marked as answer by SarahLiu Tuesday, July 08, 2014 8:27 PM
    Thursday, July 03, 2014 9:47 PM
  • Hi Kaushall_shah,

    Thanks for your reply.

    My problem is that I want to restore or recreate the sysssislog table under the System Table Folder instead of FileTables Folder.  The sysssislog table alwasys is located in the FileTables Folder using your suggestion.


    • Edited by SarahLiu Tuesday, July 08, 2014 8:33 PM
    Tuesday, July 08, 2014 8:32 PM