Solved

How to open *.dts file in SQL2005

Posted on 2009-05-06
6
856 Views
Last Modified: 2012-06-27
I wonder how do I open file with extension *.dts, I tried with business intelligent mgmt studio but not able to see the content
0
Comment
Question by:motioneye
  • 4
6 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24314149
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24314154
0
 

Author Comment

by:motioneye
ID: 24314246
You know in sql2000 we can edit the package but just right click and open dts packages, but how about in SQL2005? the link given was actually for sql2000
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 31

Expert Comment

by:RiteshShah
ID: 24314302
Are your packages belongs to SQL 2005?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24314335
you have to migrate your .DTS to .DTSX

have a look at

http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24315080
Using SSMS:
1. Expand the Management object.
2. Expand the Legacy object.
3. Right click on Data Transformation Services.
4. Select "Open Package File ..."
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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.

821 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