Data Conversion Task Error

-

hi all, have table in excel below. , trying move records excel sql.

code     template      exporttype

a002      a002xm08    dst           

---           ------           ---

i have simple ssis package excel source, data conversion task , oledb destination. , in data conversion have given data type string(dt_str) each of column , length of data type same each column having in sql database still fails @ data conversion task , gives following error: 

 

error: 0xc02020c5 @ data flow task, data conversion [2329]: data conversion failed while converting column " exporttype" (3519) column "copy of exporttype" (3533). conversion returned status value 4 , status text "text truncated or 1 or more characters had no match in target code page.".

error: 0xc020902a @ data flow task, data conversion [2329]: "output column "copy of exporttype" (3533)" failed because truncation occurred, , truncation row disposition on "output column "copy of exporttype" (3533)" specifies failure on truncation. truncation error occurred on specified object of specified component.

any plz.

hello learning_sql,

 

maybe there unicode data coming in excel column can't converted dt_str, study data in giving column , see if has unicode character or more length trying convert.

 

instead of truncate use delete delete records  table.

thanks



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder. ...
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more