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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 HA Cluster, Utility Controller No Data 11 59
Backup Job question 4 19
Sort by Month and Year - SQL 3 23
In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
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.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now