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 27, 2012 at 4:14 am

    #1571806

    EL Jerry (12/26/2012)

    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?

    So long as SSIS 2005 is what the server is using, yes. If the server is using 2008, though, you will probably need to work with the package in VS2008. You'll know if you get errors when trying to open the package in 2005.

    BTW, make sure to download any XML config files locally if the package uses them. That way you can point the package to a dev server while you're making your changes.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.