Does anyone use SSIS and access 2007? I am trying to do a simple package that imports data from access 2007 to SQL 2008..I have installed the Microsoft Office 12.0 Access Database Engine OLE. When i try to run it the souce icon just goes red.
does anyone know what i am missing
thanks
Fred