Problem with a simple import

Question

Problem with a simple import

Jpotucek

SSCoach

Points: 18583
More actions
December 21, 2009 at 6:41 pm

#143696

I am try to do a simple import of a few rows into an empty table and i am beyond frustrated.
Here is my Table
Create table dbo.Results (
RESULTS_DATE datetime not null,
TARGET int not null,
VALUE int not null,
SCALED_TARGET int null,
SCALED_VALUE int not null,
SUBJECT VARCHAR(18) not null,
TECHNIQUE CHAR(10) not null,
NR_PERIODS int not null) ;
I've attached the file that I am trying to import.
When I attempt to import via the MGT Studio GUI, I get this error:
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "Column 5" with a length of 50 to database column "SUBJECT" with a length of 18.
(SQL Server Import and Export Wizard)
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "Column 6" with a length of 50 to database column "TECHNIQUE" with a length of 10.
(SQL Server Import and Export Wizard)
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "Column 5" with a length of 50 to database column "SUBJECT" with a length of 18.
(SQL Server Import and Export Wizard)
Warning 0x802092a7: Data Flow Task: Truncation may occur due to inserting data from data flow column "Column 6" with a length of 50 to database column "TECHNIQUE" with a length of 10.
(SQL Server Import and Export Wizard)
I don't see anything wrong with the data.. can anyone help?

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

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

happycat59 One Orange Chip Points: 29451 More actions · Answer 1

These are warnings being issues because you have not changed the default data type for each of the fields on your input file. If you know the correct sizes (which I assume will be the size of the destination column), change the data types on your input file.

Jpotucek SSCoach Points: 18583 More actions · Answer 2

on the advanced tab of the select datasource step, I made the first column DT_Data datatype and the rest of the columns DT_STR (50) .. I received the same errors on the import..

I'm so frustrated.. it seems it should be so easy