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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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