Rea,
That is true. But if you look at what SSIS is doing, it includes some
instructions on Selecting 32-bit or 64-bit Package Execution.
If you point to the right path for the DTSRUN executable, just as SSIS can
run in 32-bit mode, you will be able to run the 32-bit DTSRun under the
64-bit installation. Therefore DTS still runs on the 64-bit server, but in
32-bit mode.
Follow the instructions in the first post to install the support for running
DTS packages. For editing them, it is probably best to use a desktop
installation of SQL Server 2000 Enterprise Manager.
(And, of course, moving on to SSIS is a good idea when you have time to do
so.)
RLF
[quoted text, click to view] "Rea" <Rea@discussions.microsoft.com> wrote in message
news:3FEBF1E4-CD62-4B3D-B982-7CE19613AEAC@microsoft.com...
> these articles state - (under "Support for Data Transformation Services on
> 64-bit Computers") - that:
> "...
> There is no 64-bit design-time or run-time support for Data Transformation
> Services (DTS) packages that were created in earlier versions of SQL
> Server
> ..."
>
> "Russell Fields" wrote:
>
>> Rea,
>>
>> The following two articles are more up-to-date:
>>
>> SQL Server 2005 Integration Services Backward Compatibility
>>
http://msdn2.microsoft.com/en-us/library/ms143706.aspx >> (You will notice that following these directions install the SQL Server
>> 2000
>> DTSRun. If it is in your execution path, the server will find it.)
>>
>> Integration Services Considerations on 64-bit Computers
>>
http://msdn2.microsoft.com/en-us/library/ms141766.aspx >>
>> RLF
>> "Rea" <Rea@discussions.microsoft.com> wrote in message
>> news:580BD1B7-409A-4587-B6E0-25F4F2B15BA6@microsoft.com...
>> > Hi all
>> > I can not find dtsrun on my 64 bit sql server (2000, sp4).
>> > Any idea why??
>> > Thanks
>> > Rea
>>
>>
>>
