Hi all!
I created a simple package that reads an Access Database with a Execute SQL Task (a simple SELECT). I used the Microsoft OLE DB Provider for Jet as Connection.
The MDB file is in a network folder (I use a UNC path), and the user account that is used to run the package under SQL Server Agent has the privileges to access that folder.
I know that Microsoft didn't release a 64-bit version of the OLE DB Provider for Jet, so I call my SSIS Package with the "Operating System (CmdExec)" type. The command line I use is this:
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /SQL "\Package" /SERVER "dv-erp" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
After I run my job, it fails in spite of using the 32-bit version of DTExec...
Can you help me, please?
Thanks!