I have migrated the DTS packages (which was running in SQL 2000 Server) to SSIS Packages (2008) (through
Migrate 2000 DTS Package option in Visual Studio). The below is error I am getting when we execute the SSIS package in SQL Server 2008 R2 Server. Environment : SQL Server
2008 R2 Version : 64 bit
Version Date  2/18/2015 5:10:15 PM
Log  Job History (Oracle to Access - PROD)
Step ID  1
Server  CSVP000A1037\WWSHRD02
Job Name  <TestJob>
Step Name  Test Oracle to Access
Duration  00:00:01
Sql Severity  0
Sql Message ID  0
Operator Emailed 
Operator Net sent 
Operator Paged 
Retries Attempted  0
Message
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.6000.34 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started:  5:10:15 PM
Error: 2015-02-18 17:10:16.42
   Code: 0x00000000
   Source: TEST_TABLE
   Description: This task does not support native Win64 environment. Please run the package in 32-bit WOW environment instead.
End Error
Error: 2015-02-18 17:10:16.42
   Code: 0xC0024107
   Source: TEST_TABLE
   Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  5:10:15 PM
Finished: 5:10:16 PM
Elapsed:  0.546 seconds
  The below one is the SQL script command which we have used in 2008 Server we are trying to execute through SQL Job scripts.
 
@command = N'dtexec /ser servername\instancename /sq Oracle2Access_PROD', @database_name = N'', @server = N'', @database_user_name = N'', @subsystem = N'CmdExec', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 0, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 3, @on_fail_step_id = 0, @on_fail_action = 2

 

I have set this package property Run64BitRunTime = False

 Please help me how to resolve the issue.

Thanks,

Vijay

The pitfall is in using Run64BitRunTime = False

It simply has no effect outside BIDS (it is a simulation).

You need to of the job or dtexec /32 switch needs to be used

Hi Xiong,

Thanks I have resolved the below after I have added the AD group name. But now I am getting a different issue while running the package.

Exception as below:
Message
canceled by user.
   at DTS.PackageClass.Execute()
   at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
End Error
Error: 2015-02-20 16:30:13.35
   Code: 0x00000000
   Source: TBL_CODE_VALUE
   Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.
   at DTS.PackageClass.Execute()
   at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
End Error
Error: 2015-02-20 16:30:13.36
   Code: 0x00000000
   Source: GRL_COLLECTION
   Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.
   at DTS.PackageClass.Execute()
   at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
End Error
Error: 2015-02-20 16:30:13.37
   Code: 0x00000000
   Source: CTN_CONTAINER_TYPE
   Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.
   at DTS.PackageClass.Execute()
   at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  4:30:00 PM
Finished: 4:30:13 PM
Elapsed:  12.558 second

This is the Overview of this Work

Overview

I have migrated the DTS packages (which was running in SQL 2000 Server) to SSIS Packages (2008) (through Migrate 2000 DTS Package option in Visual Studio).There are no errors after migration The purpose of this packages are connecting to Oracle database and generate an MDB file in the share location.

Please help me how to reolve the above issue.

Thnaks,

Vijay

  Overview
 
I have migrated the DTS packages (which was running in SQL 2000 Server) to SSIS Packages (2008) (through Migrate 2000 DTS Package option in Visual Studio).There are no errors after migration The purpose of this packages are connecting to Oracle database and generate an MDB file in the share location

Hi Xiong,

Could you please let me know how to resolve this issue.

Thanks,

Vijay