Koen Verbeeck (10/18/2013)
dan-572483 (10/17/2013)
Regarding Access: which provider are you using? JET OLEDB or ACE OLEDB? JET is only available in 32-bit, but ACE has also 64-bit providers available.
The package was designed on a 32-bit machine - from which the package works - and I'm trying to run it on a 64-bit server with 64-bit SQL. Does this mean I need a 64-bit machine with BIDS installed to edit the package?