Post reply

SQL server 2005(Standard version) Data export/import wizard

  • April 26, 2008 at 12:04 pm

    #189634

    Hello,

    I am trying to export data from access (Access 2002) to Sql server 2005(standard edition--SSMS) When I run the wizard and click finish I just see table created. I can not import data. I got error message saying--

    //Error 0xc0047fe: Data Flow Task: The product lever is insufficient for computer “Data Conversion 1”(41)//

    When I click preview button all the data shows in that pop up window but not in the physical table which created by wizard.

    How can I check the SP version of SQL server 2005?

    Thanks

    I appreciate it.

  • April 28, 2008 at 1:34 pm

    #808007

    Have you tried the 'About' under Help in SSMS?

  • August 7, 2008 at 3:30 pm

    #854801

    I think you've got 2 problems going here:

    1) DTS/SSIS isn't installed on SQL 2005 Express Edition by default. You'll need to install the client tools from either SQL 2005 Developer/Standard/Enterprise Edition.

    2) You need to do the import from the box the installation of SQL Express 2005 is on, not from your desktop.

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

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