?
Solved

SQL Job

Posted on 2014-01-16
3
Medium Priority
?
605 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 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

839 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