Can't open properly a SSIS package based job from SSMS in Visual Studio

emily_14 1 Reputation point
2020-09-29T10:23:03.77+00:00

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

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,606 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2020-09-29T10:52:34.247+00:00

    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.

    1 person found this answer helpful.
  2. Monalv-MSFT 5,891 Reputation points
    2020-09-30T02:55:52.49+00:00

    Hi @emily_14 ,

    May I know if you download SSDT for Visual Studio (VS) 2012?

    After downloading SSDT, please do the following steps:

    1. Open SQL Server Data Tools (SSDT).
    2. On the File menu, point to New, and then click Project.
    3. In the New Project dialog box, select Business Intelligence, and then select the Integration Services Project template.
    4. In Solution Explorer, right-click SSIS Packages, click Add Existing Package.

    Please refer to the following links and pictures:
    Create a new Integration Services project
    To add packages to the Deployment Tutorial project

    29283-addexistingpackage.png
    29284-addcopyofexistingpackage.png
    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.