I have a SSIS package which runs OK through VisualStudio it imports some data from a FoxPro database, however when I deploy it as a job on SQL Server 2005 I get the error
" Description: The AcquireConnection method call to the connection manager "FoxProConn" failed with error code 0xC0202009. End Error "
I have other SSIS packages that run OK as jobs, importing from excel etc so I don't think it is a permissions thing - I am running it as a cmd.exe with this
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /FILE "\\pq\SSISTester.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
is it something to do with the Fox Pro OLE DB??
Any pointers would be appreciated