On creation of SSIS Package it provides .dtsx file and at DTS it looks for .dts file

Question

On creation of SSIS Package it provides .dtsx file and at DTS it looks for .dts file

Vallu

SSC Eights!

Points: 863
More actions
May 5, 2010 at 4:14 am

#386853

Hi Greeting,
I'm using DTS for the first time and i created the SSIS package using Sql Server 2005 and it provided a .dtsx file. Now when I'm trying to open the package from DTS, it is not accepting .dtsx file. it looks for .dts only. could any one help me out?
Thanks
Vallu

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246956 More actions · Answer 1

You cannot open dtsx files in DTS.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

To give a little more explanation:

DTS is the old version of SSIS. DTS uses .dts files, SSIS uses .DTSX files.

You can compare it with .xls for Excel 2003 and .xlsx for Excel 2007.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246956 More actions · Answer 3

da-zero (5/5/2010)
To give a little more explanation:
DTS is the old version of SSIS. DTS uses .dts files, SSIS uses .DTSX files.
You can compare it with .xls for Excel 2003 and .xlsx for Excel 2007.

🙂 Yeah, that's much more helpful than my one-liner!

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

I tend to agree, that is a pretty good synopsis, although to continue the line of thought, you can upgrade a DTS to SSIS but it isn't always 100%. But you can't downgrade from SSIS to DTS.

CEWII

Vallu SSC Eights! Points: 863 More actions · Answer 5

Thanks for your replies but my query is actually I'm using Sql Server 2005's BIDS to create SSIS package. then why it gives a .dtsx file instead of .dts file. Even I try on Sql Server 2008 also and the problem is same.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

Because sql server 2005 comes with Integration Services (SSIS) and it will always output .dtsx files.

If you want .dts files, you'll have to install SQL Server 2000 (or older? I don't know, I'm not that old ;-))

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Kari Suresh Hall of Fame Points: 3712 More actions · Answer 7

Thanks for your replies but my query is actually I'm using Sql Server 2005's BIDS to create SSIS package. then why it gives a .dtsx file instead of .dts file. Even I try on Sql Server 2008 also and the problem is same.

You will always get .dtsx extension if you create package using BIDS 2005 or even with 2008. This is upgraded version.

If you want .dts extension try with SQL Server 2000.

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 8

Also, SQL Server Management Studio WILL NOT create new DTS files, even with the backward compatibility tools, you can edit them but not create new ones from scratch. MS REALLY REALLY doesn't want people creating new DTS packages.

CEWII

vince.chevens SSC Enthusiast Points: 197 More actions · Answer 9

How about installing SSIS component of SQL2005 only on your server

Phil Parkin SSC Guru Points: 246956 More actions · Answer 10

vince.chevens (9/20/2010)
How about installing SSIS component of SQL2005 only on your server

--comment deleted--

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Phil Parkin (9/20/2010)
vince.chevens (9/20/2010)
How about installing SSIS component of SQL2005 only on your server
--comment deleted--

Now, that just makes me curious 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246956 More actions · Answer 12

da-zero (9/21/2010)
Phil Parkin (9/20/2010)
vince.chevens (9/20/2010)
How about installing SSIS component of SQL2005 only on your server
--comment deleted--
Now, that just makes me curious 😀

😀 Just two seconds after submitting my initial response, which contained a question, I realised it was, as Basil Fawlty might say, BLEEDIN' OBVIOUS! An immediate edit was required to save my blushes.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 13

😀 Just two seconds after submitting my initial response, which contained a question, I realised it was, as Basil Fawlty might say, BLEEDIN' OBVIOUS! An immediate edit was required to save my blushes.

Hahaha...nice...

Raunak J