Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
huntsman_110
Starting Member
3 Posts |
 Posted - 2015-03-17 : 04:09:23
|
| Hi,I am trying to import csv file to the sql server 12 express.I am getting following error:Operation stopped...- Initializing Data Flow Task (Success)- Initializing Connections (Success)- Setting SQL Command (Success)- Setting Source Connection (Success)- Setting Destination Connection (Success)- Validating (Success)- Prepare for Execute (Stopped)- Pre-execute (Stopped)- Executing (Error) Messages * Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE [alldata] ( [Location] nvarchar(255)..." failed with the following error: "Positive number required. Parameter name: culture". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. (SQL Server Import and Export Wizard) - Copying to [alldata] (Stopped)- Post-execute (Stopped)Can someone help me to understand and resolve this problem. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-17 : 10:10:03
|
| Please post the CREATE TABLE statement. In the Wizard, in the the Select Source Table and Views screen, select the destination table and click Edit Mappings. Then in the Column Mappings screen click Edit Sql. In the Edit Sql screen, copy the Create Table statement and paste it here. |
 |
|
|
huntsman_110
Starting Member
3 Posts |
Posted - 2015-03-17 : 11:11:54
|
| hi gbritton,Thank you for your reply. Please find the create table statement below:CREATE TABLE [dbo].[Data_practice] ([Location] varchar(50),[invno no] varchar(50),[New Cust Name] varchar(50),[date] varchar(50),[Stockno] varchar(50),[QtySold] varchar(50),[Unit price] varchar(50),[Unit AC] varchar(50),[Sales Value] varchar(50),[Cost of Sales] varchar(50),[Brand] varchar(50),[Category] varchar(50),[Column 12] varchar(50),[Column 13] varchar(50),[Column 14] varchar(50),[Column 15] varchar(50),[Column 16] varchar(50),[Column 17] varchar(50),[Column 18] varchar(50),[Column 19] varchar(50),[Column 20] varchar(50)) |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-03-17 : 12:25:08
|
| That looks fine to me. Does it match what you expect?. Are you still getting the error? |
|
|
|
huntsman_110
Starting Member
3 Posts |
Posted - 2015-03-18 : 02:30:47
|
| Yes. Same error |
|
|
|
mandm
Posting Yak Master
120 Posts |
Posted - 2015-03-18 : 09:20:56
|
| The table referenced in the error message is "alldata" but the create statement you provided is for the table "Data_practice". Please provide the correct create definition and I think we'll find your error. |
|
|
|
|
|
|
|
|
import export wizard