Post reply

See "Who'" and "What" has Deployed SSIS Packages to the Server

  • November 24, 2010 at 2:16 am

    #231591

    Hello,

    a question:

    Do I See somewhere if someone has deployed a package to the MSDB. Is ther any log for this information.

    Important for me is the time, the packagename and the user

    Thanks

  • November 24, 2010 at 3:30 pm

    #1255363

    You can see the examine the sysssispackages in the dbo schema for package names and creation dates, but this date is the date stored in the package of when the package was first created and not the time which the package was uploaded.

  • November 25, 2010 at 4:32 am

    #1255520

    I don't think it is directly possible. But you can however create a trigger on the table that logs the information you need.

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

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

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