cannot import csv files into sql server 2014 developer help!
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)
Hi, I think the issue here is you aren't selecting the columns from the source database. That screen is quite fiddly to work with unless you have used it before, there are checkboxes for the columns you want to include. Is there any way you can't create the schema using the T-SQL commands, for example: create table products ( ProductID int, ProductName varchar(100), Price decimal(3,2); That is a rough example only. You can then enter data using T-SQL or the edit table option. Also can you please reply to this list rather than me personally so the discussion can flow through the list and everyone can remain involved? Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces@lists.hodgsonfamily.org] on behalf of Marvin Hunkin [startrekcafe@gmail.com] Sent: 22 July 2015 11:50 To: Blind-sysadmins@lists.hodgsonfamily.org Subject: [Blind-sysadmins] cannot import csv files into sql server 2014 developer help! 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) _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org https://lists.hodgsonfamily.org/listinfo/blind-sysadmins
Hi, I think the issue here is you aren't selecting the columns from the source database. That screen is quite fiddly to work with unless you have used it before, there are checkboxes for the columns you want to include. Is there any way you can't create the schema using the T-SQL commands, for example: create table products ( ProductID int, ProductName varchar(100), Price decimal(3,2); That is a rough example only. You can then enter data using T-SQL or the edit table option. Also can you please reply to this list rather than me personally so the discussion can flow through the list and everyone can remain involved? Thanks. Andrew. ________________________________________ From: Blind-sysadmins [blind-sysadmins-bounces@lists.hodgsonfamily.org] on behalf of Marvin Hunkin [startrekcafe@gmail.com] Sent: 22 July 2015 11:50 To: Blind-sysadmins@lists.hodgsonfamily.org Subject: [Blind-sysadmins] cannot import csv files into sql server 2014 developer help! 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) _______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org https://lists.hodgsonfamily.org/listinfo/blind-sysadmins
participants (2)
-
Andrew Hodgson -
Marvin Hunkin