How to find an SSIS

  • I am trying to decipher some error codes generated by an SSIS. I did not write the SSIS and am new to MS SQL Server 2005. I am trying to find the SSIS and figure out what it is doing. Another post suggested that the SSIS can be stored either on the file system or in a database. Is there a way to query the db for the SSIS?

    TIA

    DG

  • use msdb

    select *

    from dbo.sysdtspackages90

    order by [name]

    If you search for sysdtspackages90 in BOL it will give you the definition of these columns.

    --The folderID can be found in

    select *

    from sysdtspackagefolders90

  • Thank you, thank you, thank you!

    D

  • It would be helpful if you had a copy of the original package so you could open and test using the development studio. Does anyone there know who developed the package so you can get a copy?

  • Actually, depending on the encryption of the package strored in SSIS, you may be able to export this package from SSMS Intergration Services to a .dtsx disk file, create a new Intergration Services solution in BIDS and then add this package to the solution.

    I've done that several times in the past with out existing packages.

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

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