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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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.

751 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