Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to know which DTSX file was deployed in a server. RE: How to know which DTSX file was deployed in a server.

  • December 26, 2012 at 3:03 pm

    #1571690

    Thank you for your response, Greg.

    Greg Edwards-268690 (12/26/2012)

    If being run as a SQL Agent Job, you should be able to track down if it is in MSDB or being run from the file system.

    Then you can either Export from MSDB (see Books Online), or take a copy from the file system.

    I can see it in SSIS\Stored Packages\MSDB. Can I just export it and work with in in VS2005?

    Whatever you end up doing, consider some documentation and source control.

    As you can see, it is not much fun to inherit and have to pick up the pieces.

    Especially if you guess wrong. :crazy:

    Definitely!! 😀

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]