Re: How to open sql 2000 DTS package in sql 7?

So long as you have SP3 on the 7 box and the 2000 package is not using 2000
only tasks.

if you do not have SP3 then make sure you save the 2000 package with a
password

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"bluemug" <jianyangtai@xxxxxxxxx> wrote in message
news:1123021430.724527.268410@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> Our partner created a DTS package in sql 2000. However, we are still
> running sql 7 and can't upgrade in the short term. Is there anyway to
> open that DTS package in sql 7 or somehow "save" the package in sql
> 2000 as a sql 7 version?
>
> Or is this mission impossible?
>
> Thanks,
> bluemug
>


.

Relevant Pages

  • Re: more detail on issue
    ... then have SQL and SQL Agent running as an ... When you installed the package to your SQL ... Server, did it prompt you for the password you packaged with? ... strings not being visible to the SQL Agent user. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Designer without a server.
    ... You can design your DTS package locally (if it's a SQL to SQL ... On the target server richt click Data ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS schedule problem
    ... I found out that the package, sql server agent were running under the SQL ... Who owns the scheduled SQL Agent job? ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS on Sql 2005
    ... What is the difference in the query plans between the two statements? ... I manually open the DTS package and run on Sql 2005 after import. ... "Allan Mitchell" wrote: ...
    (microsoft.public.sqlserver.dts)