SQL Import Error 0xc02020c5: Data Flow Task

SQL 2008
Windows 2008 Server
Windows 7 Pro
Excel 2010
All 64 Bit

When trying to import a spreadsheet with over 32000 rows in stop at row 20296

See SQL Report attached.

Been trying several times no luck.

Any help would be great.
Report3.txt
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Eugene ZConnect With a Mentor Commented:
as you can see from the error " The conversion returned status value 6 and status text "Conversion failed because the data value overflowed the specified type.".

your existing destination  dbo].[Tracks] table is not happy to accept data from excel

you can go via each of problematic columns and check in excel
what is wrong with
row 20296 "TrackSequence" column value and fix it
or set Tracks table "TrackSequence" column to appropriate size\datatype
or try to load all into  a new table  and adjust datatypes  and size for problematic columns
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
EugeneZ

I figured it out late last night

I had a filed defined as tinyint  changes to charvar it the data imported.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.