?
Solved

SQL Job

Posted on 2014-01-16
3
Medium Priority
?
603 Views
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 ?

Tks
SQL-Job.png
0
Comment
Question by:AXISHK
[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
3 Comments
 
LVL 9

Expert Comment

by:gt2847c
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.
0
 
LVL 37

Accepted Solution

by:
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.
0
 

Author Closing Comment

by:AXISHK
ID: 39790234
Tks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

765 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