Post reply

Can't run package via SQL Agent

  • March 14, 2022 at 5:04 pm

    #3999236

    Hi all,

    I didn't manage to run the SSIS Package via SQL Agent.

    I can do it manually but when I execute the job via SQL Server - package is down with an error "oXC0208449 the specified DSN contains an architecture mismatch" .

    I have 64 windows.

    ODBC Driver was set up for 32. Also, in properties of package I used 32 mode.

    Could you please help me?

  • March 14, 2022 at 5:18 pm

    #3999239

    Package properties don't affect the bitness when set up as an Agent job.

    Instead, to run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use 32 bit runtime on the Execution options tab of the New Job Step dialog box.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 14, 2022 at 5:32 pm

    #3999248

    Phil,

    Could you please clarify where I can find it?

    I didn't see such option in SQL Agent.

  • March 14, 2022 at 5:42 pm

    #3999259

    32bit

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 21, 2022 at 2:57 pm

    #4003460

    Thanks! It works

Viewing 5 posts - 1 through 4 (of 4 total)

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