Sql Agent won't execute package

  • I have an SSIS package that has a step an activeX script that executes an http request and stores response in a variable for downstream processing. Worked fine for months till I moved it to a new 64 bit server. I've gone through a number of references, and came to the conclusion that the script step causes the issue. My approach has been one suggested on msdn, to run the package in 32 bit mode:

    1. import the package to the file system on the server

    2. use the dtexecui.exe utility to create a command line for 32 bit execution of the package

    3. create a sqlAgent job with a step of type CmdExec, run from sqlService acct, and paste in command line created in step 2.

    Here is the command line generated by dtexecui.exe:

    /DTS "\File System\Navision_Oanda" /SERVER NTdwdevsql01 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

    4. schedule the job so that execution is on the server.

    The problem now is the following error content:

    Date11/13/2008 2:26:20 PM

    LogJob History (navision oanda 32 bit)

    Step ID1

    ServerNTDWDEVSQL01\DLDWLD2

    Job Namenavision oanda 32 bit

    Step Namenavision oanda 32 bit step

    Duration00:00:00

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: NTR\sqlservice. The process could not be created for step 1 of job 0xEDAB0D6D538C8445A48D99BB61489110 (reason: The system cannot find the file specified). The step failed.

    Is there some manual edit of the command line that needs to take place before I try to use it in the job? Any help would be appreciated greatly!

  • What you have to do is select the 32bit version of DTEXEC. SQL 2008 includes new option in the SQL Job Agent step setup, which gives you easy setup . In SQL 2005, you should not use Integration Services Package step . You should insert "Execute Process" step and select the 32 bit DTEXEC , which is by default located in:

    \\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn

    Select DTEXEC and use whatever execution parameters you require.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply