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?