July 7, 2011 at 2:22 pm
I am migrating many dts packages from SQL 7 to SQL 2000 server. I am using below script to do this so that I get the latest version of all the dts packages.
select name, max(createdate) as maxdate into #test from sourceserver.msdb.dbo.sysdtspackages -- sql7
group by name
insert into destserver.msdb.dbo.sysdtspackages -- sql2000
select s.* from sourceserver.msdb.dbo.sysdtspackages s
join #test t
on s.name = t.name
and t.maxdate = s.createdate
This executes without any problem and after that I also see all the packages listed in SQL 2K Enterprise Manager. but when I double click on any package it errors out as below,
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: The specified file is not a package storage file
Am I doing anything wrong here? Thanks in advance...
July 7, 2011 at 2:34 pm
Not sure what you are doing wrong, but I'm weary of doing a direct insert from an older version to a newer version, I think thats asking for trouble.
If I may make a suggestion. I built a utility to move packages from SQL 2000 boxes to other SQL 2000 boxes, never tried it on SQL 7, but it may work.. It is at:
http://ncldts.codeplex.com/[/url]
There is a packaging and a deployment app.
CEWII
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply