Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How can I view an SSIS pkg stored in SQL Server 2005 Maintenance Plans?

Posted on 2010-09-13
2
Medium Priority
?
531 Views
Last Modified: 2013-11-10
Here is what happened:
1.  SQL Server 2005 Management Studio
2.  Tasks > Export data
3.  Wizard gives you the option to Execute Immediately and/or Save as an SSIS package
4.  Selected option to Exec Imm and Save SSIS package to File System (pkg protection level = default = encrypt sensitive data with user key)
5.  SSIS pkg named, described and saved to a local path (filename.dtsx)
6.  SQL Server 2005 Business Intelligence Development Studio > File\Open the previously saved dtsx file
7.  Modified the SSIS package in the BIDS designer gui.
8.  Used the File > "Save" option to save the modified SSIS package in SQL Server under the "Maintenance Plans" list tree.
9.  Back in SQL Server Mgt Studio, created a Job with Step 1 that executes an SSIS pkg.
10.  The job step's General Properties specifies Type = SQL Server Integration Services Package, Run As: SQL Agent Service Account, Package Source = SQL Server, Server = [the SQL 2005 instance where the pkg was Saved to], Windows Authentication selected, and the Package location was selected by hitting the ellipsis button ... this let me browse the SQL Server instance for the saved package, which I found under the "Maintenance Plans" node.
11.  The original DTSX file object is now gone - someone deleted the file and its containing folder and it cannot be recovered.
12.  The modified SSIS package is being executed as Step 1 of the SQL Job, but now a new requirement means the SSIS package needs to be modified.
13.  The SSIS package apparently is "stored" in the SQL Server instance under something called "Mainteance Plans", but I need to find it so that I can open it in the BIDS designer to make the necessary design changes.  
14.  I am using the same Windows account and same SQL account (as applicable) as were used when the original DTSX file object was opened and modified in BIDS, and then saved as an SSIS package in SQL Server, under the "Maintenance Plans" tree node.  
15.  I now cannot find a way to open / retrieve that SSIS package.  Where is it?  How do I open it so I can modify and/or save it as a DTSX object again?   Screen shot of the SQL job step is attached.
SQL-2005-job-with-SSIS-pkg-in-St.jpg
0
Comment
Question by:jfvassar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 2000 total points
ID: 33666566
you can open BIDS again, create new ssis package
right click on "ssis packages" folder
select "add existing package",
now you can add package from file system/ sql server/ ssis package storage


0
 

Author Closing Comment

by:jfvassar
ID: 33689848
Thanks!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question