"RichardT" <RichardT@discussions.microsoft.com> wrote in message
news:6D1AAB64-C1D4-48FB-A1F5-8C6931845457@microsoft.com...
> Hi,
>
> At the moment I'm trying to run it under the Legacy Data Transformation
> Services and calling it with DTSRun.
>
> Richard
>
> "Francisco A. Gonzalez" wrote:
>
>> Hi
>> Is your dts package within the SSIS execute DTS package task,
>> this task does not work on 64 bits,
>> is this you case?
>> cheers
>>
>> --
>>
>> Francisco A. Gonzalez
>> fgonzalez@solidq.com
>>
>>
>>
>> "RichardT" <RichardT@discussions.microsoft.com> wrote in message
>> news:5A379BB7-1DBA-465B-A0CE-34F1544040E0@microsoft.com...
>> > Hi,
>> >
>> > I've got a package that runs ok on 32bit SQL 2005 SP2 on a single node,
>> > but
>> > when I move it to SQL 2005 x64 cluster I get the error:
>> >
>> > Message
>> > Executed as user: CORP\xs-sql-prod. DTSRun: Loading... DTSRun:
>> > Executing... DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
>> > DTSRun
>> > OnFinish: DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart:
>> > DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
>> > DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9)
>> > Error
>> > string: ActiveX Scripting was not able to initialize the script
>> > execution
>> > engine. Error source: Microsoft Data Transformation Services
>> > (DTS)
>> > Package Help file: sqldts80.hlp Help context: 4500
>> > Error
>> > Detail Records: Error: -2147220487 (800403F9); Provider Error: 0
>> > (0)
>> > Error string: ActiveX Scripting was not able to initialize the
>> > script
>> > execution engine. Error source: Microsoft Data Transformation
>> > Services
>> > (DTS) Package Help file: sqldts80.hlp Help context: 4500
>> > DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package
>> > execution
>> > complete. Process Exit Code 1. The step failed.
>> >
>> > There are no corresponding windows eventlog entries.
>> >
>> > Any thoughts?
>> >
>> > Thanks, Richard
>> >
>>
>>
>>