sql server 2008 - SQL Agent job fails to execute -
this question has answer here: running ssis package using dtexec 2 answers i run package in server, worked fine when used run in sql agent job, failed execute. microsoft (r) sql server execute package utility version 10.50.4000.0 64-bit copyright (c) microsoft corporation 2010. rights reserved. started: 2:05:54 pm error: 2014-02-05 14:06:00.54 code: 0xc0047062 source: data flow task ado net source [1] description: system.data.odbc.odbcexception: error [im002] [microsoft][odbc driver manager] data source name not found , no default driver specified @ system.data.odbc.odbcconnection.handleerror(odbchandle hrhandle, retcode retcode) @ system.data.odbc.odbcconnectionhandle..ctor(odbcconnection connection, odbcconnectionstring constr, odbcenvironmenthandle environmenthandle) @ system.data.odbc.odbcconnectionopen..ctor(odbcconnection outer...