How to open *.dts file in SQL2005

Posted on 2009-05-06
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
Question by:motioneye
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
  • 4
LVL 31

Expert Comment

ID: 24314149
LVL 31

Expert Comment

ID: 24314154

Author Comment

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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

LVL 31

Expert Comment

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

Accepted Solution

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

have a look at
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 ..."

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

617 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