locked
cannot import csv tables into a sql server 2014 database RRS feed

  • Question

  • hi. trying to import a table into sql server developer 2014. went with the 64 bit import and export wizard, as the 32 bit would not let me set a connection string. and my lectuer said to create a access database, so i imported the tables, set it up. and did save it as .mdb. but when i tried to import into sql management studio, says the format is unreconginizeable. have got the two tables, schemr set up in sql management studio. can any one help me, is there an easier way or more accessible screen reader tools to allow me to import .csv files into sql management studio. will paste the errors below. can any one help. totally frustrated. marvin. ps: either i am doing some thing wrong or stupid, or it is not liking it for some reason. frustrated. tried googling the errors, but could not seem to find an answer. frustrated! need this for an assignment. not to do it for me, but a solution to help me out. marvin. ps:: the results screen, cannot seem to click on the links, with my screen reader, and when i try, it does not go to that, so totally frustrated and getting annoyed. will paste below.

    Operation stopped...

    - Initializing Data Flow Task (Success)

    - Initializing Connections (Success)

    - Setting SQL Command (Success)

    - Setting Source Connection (Success)

    - Setting Destination Connection (Success)

    - Validating (Error)
    Messages
    Error 0xc020201b: Data Flow Task 1: The number of input columns for Destination - StockPrices.Inputs[Destination Input] cannot be zero.
     (SQL Server Import and Export Wizard)
     
    Error 0xc004706b: Data Flow Task 1: "Destination - StockPrices" failed validation and returned validation status "VS_ISBROKEN".
     (SQL Server Import and Export Wizard)
     
    Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
     (SQL Server Import and Export Wizard)
     
    Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
     (SQL Server Import and Export Wizard)
     

    - Prepare for Execute (Stopped)

    - Pre-execute (Stopped)

    - Executing (Success)

    - Copying to [dbo].[StockPrices] (Stopped)

    - Copying to [dbo].[OrderDetails] (Stopped)

    - Post-execute (Stopped)


    http://startrekcafe.stevesdomain.net http://groups.yahoo.com/groups/JawsOz

    Wednesday, July 22, 2015 10:49 AM

Answers

All replies