YCH (4/1/2010)
"Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server..."
post the complete error and query you are using in job.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)