Solved

SQL Job

Posted on 2014-01-16
3
600 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
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 500 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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 Backup & Restore 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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 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