> Hi All,
>
> I have a large DB with 111 DTS's in Sql2000 and I need to move them to a
> New
> Server and Domain. What will be the best way to approach it. Since these
> DTS's are complex, I don't want to upgarde them but to move them saftly to
> sql2005.
>
> Advise,
> Naana.
>
> --
> Message posted via http://www.sqlmonster.com

> Yes, I was able to import the dts from sql 2000 into sql 2005 but could
> not
> open the dts. I get error message to install "Sql Server 2000 DTS Designer
> Components". I can't find this component so should install Sql 2000 on the
> Server?.
>
> Keith Kratochvil wrote:
>>You could save the DTS package (on the 2000 box) as a .dts file.
>>
>>You would then right-click on the Data Transformation Services folder on
>>the
>>2k5 box and choose "Import Package File"
>>
>>> Hi All,
>>>
>>[quoted text clipped - 6 lines]
>>> Advise,
>>> Naana.
>
> --
> Message posted via http://www.sqlmonster.com

>You want to grab the SQLServer2005_DTS package from here:
>http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en
>
>> Yes, I was able to import the dts from sql 2000 into sql 2005 but could
>> not
>[quoted text clipped - 13 lines]
>>>> Advise,
>>>> Naana.