June 5, 2009 at 6:57 am
Hi all.
I build a ssis package for exporting some data out of my sql2008 db into a excel 2003 sheet. When i start this package manually, both File System in in DB, this works perfectly.
But now i want to schedule this package to run every day. So i made a new Job pointing to the ssis package:
First error i got had to do with 32 bit vs. 64 bit. Enabling 32bit Run Time did the trick. Now i get the following error in the logfile:
Code: 0xC0202009
Source: ssispackagename Connection manager "Excel Connection Manager"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Q:\File Path To\001invoices.xls is not a valid path. Make sure the pathname is spelled correctly and that you have a connection with the server on which the file is located.".
Q:\ is a mapped network drive and definitely available. On the net i found some information, saying that SQL Server Agent may has no rights on that folder. But i can't select the SQL Server Agent when i define permissions on folders.
Again, when started manually this works ok.
Can somebody point me in the right direction?
Thnx! 😎
June 5, 2009 at 7:17 am
Is Q: on another server. It looks like the agent may not have access. I always run the Agent service (and the SQL service) as a Windows domain account that way I can assign it rights.
June 5, 2009 at 7:25 am
The Q drive is probably not mapped within the context of the SQL account.
You would be better served replacing the Q mapped drive with the regular UNC path.
June 8, 2009 at 5:46 am
Thanks that was it. Instead of Q:\ use \\SERVER\....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply