[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

SQL server 7.0 DTS package

I have a MS SQL server 7.0. There are some DTS packages. When I try to open the DTS package, I amgetting the following error:
Error Source: MS DTS package
Error description: The system can not find the file specified.

This applies to any DTS I try to open. If I can not open the DTS (maybe they are corrupt), I would like to recreate them. Is there a way to export the content of the DTS package, so i can see what was there originally.

Thanks
0
techzone12
Asked:
techzone12
  • 6
  • 5
  • 3
  • +1
1 Solution
 
Reza RadCommented:
I think those packages created by sql server 2000 dts designer
and you must run them in enterprise manager 2000
try this and let me know the results
0
 
techzone12Author Commented:
OK. It looks that I will have to apply SQL 7.0 SP3. I don't seem to be able to find the installation file to download. Microsoft is giving me "the run around"..!!
0
 
Reza RadCommented:
also you can do this with sql server 7 sp3.
from here:
http://support.microsoft.com/kb/274799/

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
techzone12Author Commented:
MS is re-directing me to SQL 2005 download page? I still can not find the download.. still looking..
0
 
Reza RadCommented:
0
 
Reza RadCommented:
let me know if you have problem yet
0
 
techzone12Author Commented:
I tried to download the file. I am getting errors. "The requested site is eaither unavailable or cannot be found.."
0
 
techzone12Author Commented:
I think the download of the executable is maybe being blocked, I will try it when I get home..
0
 
Anthony PerkinsCommented:
>>Microsoft is giving me "the run around"..!!<<
Which is not surprising, since this product is no longer supported.

Incidentally, the last Service Pack was SP4 and not SP3
0
 
James MurrellProduct SpecialistCommented:
0
 
Anthony PerkinsCommented:
Unfortunately that link points to SQL Server 2000 SP4, but the author is using SQL Server 7.
0
 
techzone12Author Commented:
Only option, it looks like, is to upgrade SQL 7.0.
0
 
Anthony PerkinsCommented:
If you mean upgrade to SQL Server 2008, then yes that is your best option.
0
 
Reza RadCommented:
Yes, I suggest you 2008 too, don't hesitate on this upgrade.
0
 
Reza RadCommented:
you can migrate your dts packages to SSIS , I mean Sql Server Integration Services this is new version of DTS.
you have BIDS in 2008 . a great designer for SSIS packages with much more abilities than old DTS.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 6
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now