package points to a Maintenance Plan
If it's a maintenance plan, then connect with with SSMS to the database engine, not integration service.
Open node "Management" => "Maintenance Plan", there you should find the plan.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I need to understand what a certain job in SQL Server 2012 does. It's a job someone created and left the company before I started to work here, and nobody on my team knows what this job does also.
The job isn't SQL command based but SSIS Package (which I'm not familiar with), the package points to a Maintenance Plan with the same name as the job. As I read on the internet I connected via Integration Services type, then Stored Packages -> MSDB -> Maintenance Plans, right click on the Maintenance Plan and exported it to a .dtsx file.
I opened it in Visual Studio 2010 Shell, but I can't edit anything because of this error:
The task with the name "" and the creation name "" is not registered for use on this computer.
I also don't have a Solution Explorer for that package, and the icons of the tasks seem a bit faded compared to tasks icons of a new project if I create one.
Maybe the dated version of the VS can be the problem? Perhaps there is other way to see what this job does?
I never worked with SSIS before so maybe I'm missing something very basic but I've been on the Internet for days already and can't find any solution.
Please help,
Thanks in advance
package points to a Maintenance Plan
If it's a maintenance plan, then connect with with SSMS to the database engine, not integration service.
Open node "Management" => "Maintenance Plan", there you should find the plan.
Hi @emily_14 ,
May I know if you download SSDT for Visual Studio (VS) 2012?
After downloading SSDT, please do the following steps:
Please refer to the following links and pictures:
Create a new Integration Services project
To add packages to the Deployment Tutorial project
Best Regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.