May 5, 2010 at 4:14 am
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
May 5, 2010 at 4:21 am
You cannot open dtsx files in DTS.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 5, 2010 at 5:53 am
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
May 5, 2010 at 6:44 am
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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 5, 2010 at 7:00 am
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
May 5, 2010 at 8:04 am
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.
May 5, 2010 at 8:06 am
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
May 5, 2010 at 8:56 am
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
May 5, 2010 at 9:19 am
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
September 20, 2010 at 8:24 am
How about installing SSIS component of SQL2005 only on your server
September 20, 2010 at 11:36 am
vince.chevens (9/20/2010)
How about installing SSIS component of SQL2005 only on your server
--comment deleted--
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 21, 2010 at 12:38 am
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
September 21, 2010 at 1:59 am
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 21, 2010 at 4:35 am
😀 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
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply