Can't run package via SQL Agent

  • 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?

  • 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.


  • Phil,

    Could you please clarify where I can find it?

    I didn't see such option in SQL Agent.

  • 32bit


  • Thanks! It works

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

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