Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 0xc02020c5: Data Flow Task 1:

Status
Not open for further replies.
ddaughtery1

ddaughtery1

Programmer
Feb 5, 2009
1
US
I am trying to import via the import wizard data from a txt file which is tab delimted int a staging table and I'm getting the following error and don't know what to make of it:

Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting column "Column 1" (14) to column "Column 1" (113). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

 
Sort by date Sort by votes
your destination column width is to small for the data.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
307
grnzbra
grnzbra
how2trainyourdragon
  • Locked
  • Question
SSIS Web Service task SSL errors
Replies
1
Views
315
how2trainyourdragon
how2trainyourdragon
sugu.bala
  • Locked
  • Question
Dynamic Input column in Script task
Replies
0
Views
290
sugu.bala
sugu.bala
kfschaefer0727
  • Locked
  • Question
New to SSIS - Create pkg to validate data, does it exists in a table
Replies
0
Views
270
kfschaefer0727
kfschaefer0727
rohitkochar123
  • Locked
  • Question
OLE DB Command Input has lineage ID 3293 that was not previously used in the Data Flow task.
Replies
0
Views
293
rohitkochar123
rohitkochar123

Part and Inventory Search

Sponsor

Back
Top