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