none
Error Importing data

    Question

  • Hi All

     

    Im running SQL Express 2005 on my 64bit windows 2003 R2 server, and im having a problem converting some data over to the database. The error i get is:

     

    There was a problem connecting to the library.mdb database (NormalSystem)

    Additional Information:

    Error [IM002] [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.

    I have done a couple of searches on the net, but not found anything to do with SQL express 2005, and it mentions something about run64bitruntime.exe. I cannot seem to find this option anywhere in SQL server management studio Express.


    Can someone help me on this issue


    Thanks


    Tim.

     

    Thursday, May 01, 2008 12:21 PM

Answers

  • SQL Server Express does not have the SSIS Import/Export Functionality in it.  This is one of the items that was left off of the Express Edition and is only available in the Developer/Standard/Enterprise Editions.

     

    Thursday, May 01, 2008 1:23 PM