Brandie Tarvin (12/27/2012)

---

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.