July 30, 2013 at 2:39 pm
I can't believe I'm having this much trouble with this, but I am stuck. I have a .dts package that was saved to a SQL Server 2000 database. Unlike what I'm used to, I cannot seem to access this file in Visual Studio 2008.
I know that there will be a compatability issue with this, and the main thing I am trying to do is test out how to do this so that I will have a solution ready when I need to make these changes in the near future. Can anyone offer any advice? Can you tell me if what I'm seeing sounds correct (i.e. - I cannot track down an acctual .dts file. Instead I only see the package created on the server. I thought it was in SQL Server 2005 that first allowed that.)?
Thank you,
Jarid
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
July 30, 2013 at 3:02 pm
Not used SQL 2000 for awhile but can you right click the DTS in question on the server then export as the dts file?
August 6, 2013 at 9:55 am
You need to install SQL 2005 backward compatibility and the DTS designer components in order to edit DTS packages with SQL 2008. Ther are also some post-install steps you have to do manually.
This link has the tasks you need to do, and you can probably find some more advice via Google. http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20DTS%20Designer
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 6, 2013 at 2:15 pm
I appreciate the advice. I lucked out (depending on how you look at it). We are going to go ahead with the conversion to 08R2, and I'll have the .dts to .dtsx conversion tools. I'm glad we won't have these questions floating around for too much longer.
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply