I'm trying to find the code used for a Maintenance Plan SSIS package that is stored in SQL server as a SQL Server Integration Services Package. I've tried logging into the Integration Services on the server, but it returns an error that it failed to retrieve data for this request. Unfortunately I wasn't the one that set up this package, so I'm not sure where the original files are or if they even exist at this point.
I need to find the dtsx file or something similar so that I can determine what steps are being performed and modify them as necessary. This is on SQL Server 2012 and the package is being referenced from the SQL Server Job Activity Monitor.
Thank you in advance for any help you can provide.
First in the job located in SQL Agent in SSMS, go to the step where the type is SQL Server Integration Services.
The general tab will give you the location. What is the package source? If it's the file system, the file is located on the server you are logged into via SSMS and at the specified package destination.
If the source is SQL Server, you will need to log in to the panel there. If it's SSIS Package Store, you will use windows authentication.
This link will help provide more information on the location of the package. From there, you will have to edit it in visual studios.