Integration Services and Access 2007

  • 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

  • Please ignore this..I was trying to run it with windows server 2008.

    I think its because all the access drivers were not installed.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply