DTS packages in SQL Server 2005

[Database Administrator]

I understand that DTSRUN is not supported in pure 64 bit. Is it supported
under X64 (ie just runs as a 32 bit app) ?

thanks
Peter

[Database Administrator]

On Jul 22, 12:04 am, Peter Feakins
wrote:
> I understand that DTSRUN is not supported in pure 64 bit. Is it supported
> under X64 (ie just runs as a 32 bit app) ?
>
> thanks
> Peter

Hi Peter,
DTS are supported in SSIS, that is is possible to run old dts packages
because there's a new task for this purpose.
In SSIS you use DTEXEC (or similar) to run the packages and _I don't
believe you can launch them with DTSRUN_.
I know there's a dtexec for 32bit too (C:\program files
(x86)\microsoft sql server\...). For some ssis packages (with jet ole
db connection) I use the 32bit version, check this site:
http://technet.microsoft.com/en-us/l.../ms141766.aspx

Hope this helps!
M.

[Database Administrator]

Sorry that didn't answer the quesstion. I need to know if I can still run DTS
packages using DTSrun in SQL Agent on an x64 machines. My understanding is
that DTSRun is a 32 bit executable installed as part of the backward
compatibility pack.

"matteus" wrote:

> On Jul 22, 12:04 am, Peter Feakins
> wrote:
> > I understand that DTSRUN is not supported in pure 64 bit. Is it supported
> > under X64 (ie just runs as a 32 bit app) ?
> >
> > thanks
> > Peter
>
> Hi Peter,
> DTS are supported in SSIS, that is is possible to run old dts packages
> because there's a new task for this purpose.
> In SSIS you use DTEXEC (or similar) to run the packages and _I don't
> believe you can launch them with DTSRUN_.
> I know there's a dtexec for 32bit too (C:\program files
> (x86)\microsoft sql server\...). For some ssis packages (with jet ole
> db connection) I use the 32bit version, check this site:
> http://technet.microsoft.com/en-us/l.../ms141766.aspx
>
> Hope this helps!
> M.
>

[Database Administrator]

I just created a SSIS package and added an Execute DTS 2000 Package
Task.
I set its properties to look for a DTS on a SQL 2000.
I run the package from dev studio: OK
I saved it on MSDB in SQL 2005, I created a job that runs that package
(as an Integration service type) and run it:
Code: 0x00000000 Source: Execute DTS 2000 Package Task
Description: This task does not support native Win64 environment.
Please run the package in 32-bit WOW environment instead.

I then changed the step type to cmdexec and added the following line
before command arguments: "C:\Program Files (x86)\Microsoft SQL Server
\90\DTS\Binn\dtexec.exe": OK.

So if you need to run DTS package in a 2005 agent job, you can with
some workaround...
If you need to run a DTS package on a 2005 job using DTSrun, you can
try copying dtsrun and related .dlls onto a folder (or installing
sql2000 client) on your server and then schedule a job with a cmdexec
with dtsrun, just like you did in sql2000.
Bye,
M.