Binary Data conversion error in DTS.

• Subhash-141882

  Ten Centuries

  Points: 1294

  More actions

  November 26, 2004 at 6:49 am

  #59812

  Hi All,

  I have a data conversion error while importing data using DTS.

  I have 2 different SQL servers 1 :   Client and

                                           2 : Local.

  I'm exporting the data from SQL server #1 (Client)  into .xls (Excel) and from there again i'm importing back to my server #2 (Local).

  While doing this, one of my table have got Binary data column and when importing back to my server #2, i'm getting the data conversion error.

  "TransformCopy 'DirectCopyXform' conversion error:  General conversion failure on column pair 18 (source column 'DSPLKUPS' (DBTYPE_WSTR), destination column 'DSPLKUPS' (DBTYPE_BYTES))."

  Please let me know how to get rid of this conversion problem.

  Thanks in Advance,

  Subhash

   

• Ste_P

  SSCarpal Tunnel

  Points: 4430

  More actions

  November 26, 2004 at 7:09 am

  #531600

  Hi,

  Looks like you have unicode data that you are passing into a binary field. Using an explicit CAST or CONVERT should cure the problem.

  Have fun.

  Steve

  We need men who can dream of things that never were.

• Subhash-141882

  Ten Centuries

  Points: 1294

  More actions

  November 26, 2004 at 7:18 am

  #531603

  Yes Steve,

  I have encrypted data in the said Binary column. I'm not even editing any VBScript code generated by it. For converting or casting, where can we edit.. do we need to edit the generated VbScript code, if so can you plz help me in vbScript syntax for this conversion.

   

  Thanks,

  Subhash