Post reply

SSIS

  • November 24, 2008 at 3:15 pm

    #203306

    How is SSIS stored in SQL Server 2005? Do they exist in some tables in msdb? I need to update some properties (for e.g logging) on all of the packages..I am trying to see if I can mass update the table instead of brining SSIS to BI and upload them in the server again. Any help would be appreciated.

  • November 24, 2008 at 5:08 pm

    #902822

    When you save a package you choose whether to save it to SQL Server or to the file system. If the package is saved to SQL Server, it's stored in msdb.dbo.sysdtspackages90 in an image column. I don't think you could modify a package by updating the table.

    Greg

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

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