Sunday, February 26, 2012

DTSRUN is it available in SQL Server 64-bit

Hi There,
Tried to look for the DTSRUN utility in SQL server 64-bit , but wasn't
able to locate it, is it supported to run on the 64-bit server? if not , are
there any alternatives rather than using BCP or running the DTSRUN utility
from a 32-bit machine.
Thanks in advance
Asser MaanyHi
The short answer. No.
The long answer. You could install it in the WOW64 (Windows on Windows - a
64 to 32 bit Thunking layer present in 64 Bit Windows), but, it will not be
supported by Microsoft.
It is best to run EM and DTSRUN on a 32 bit server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Asser Maany" <asser.maany@.microtech.com.eg> wrote in message
news:OCL17fVrFHA.3836@.TK2MSFTNGP12.phx.gbl...
> Hi There,
> Tried to look for the DTSRUN utility in SQL server 64-bit , but wasn't
> able to locate it, is it supported to run on the 64-bit server? if not ,
> are there any alternatives rather than using BCP or running the DTSRUN
> utility from a 32-bit machine.
> Thanks in advance
> Asser Maany
>

No comments:

Post a Comment