wyliec2
SSC-Addicted
Points: 468
More actions
April 24, 2007 at 7:32 am
#702160
If you're running 64-bit check this thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=357285
There are several threads dealing with the workaround needed for SQL Agent to run jobs requiring OLEDB providers which do not have a 64-bit version available (ie. Access and Excel do not have 64-bit providers).
Jason Coleman
SSCrazy
Points: 2187
April 27, 2007 at 1:59 am
#702859
Thx wyliec2 - i changed the job under the sql agent to run using the cmdexec property and it works fine.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply