Posted on 2014-01-16
Medium Priority
Last Modified: 2016-02-10
Any idea what type of job created under my SQL 2008 R2 server (marked with SSIS Package) ? How can I open the detail of the package ?

Question by:AXISHK

Expert Comment

ID: 39787467
It's a SQL Server Integration Services package.  The package referenced will have a .dtsx file that can be opened with SQL Server Data Tools.

You can get a copy here.

SSIS is a ETL (Extraction, Transform, Load) tool set that is used to carry out many tasks from bulk loading data (with or without changes), maintenance functions ( in your case, it looks like it is used to re-index tables), etc.
LVL 37

Accepted Solution

ValentinoV earned 2000 total points
ID: 39787951
gt2847c: SQL Server Data Tools is not meant for BI (SSIS, SSRS, SSAS) development, it's for database projects only.  You're probably confusing it with this: Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012

AXISHK: in SQL Server 2008 you can use the Business Intelligence Development Studio to develop SSIS packages.  This ships with the SQL Server setup.

Also, from your screenshot I can tell that the package is deployed inside the MSDB.  To retrieve the package from the server you can connect through the Management Studio to your SSIS instance.  To do that: Object Explorer > Connect dropdown > Integration Services... Open up the tree structure to Stored Packages > MSDB > Maintenance Plans...

You should now see the package.  Right-click it > Export Package... Select File System as Package Location and specify a full path + name as Package Path.  So specifying c:\test.dtsx will create a test.dtsx package in the C: root.

Author Closing Comment

ID: 39790234

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
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 …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

624 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