Post reply

Binary Data conversion error in DTS.

  • 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

     

  • 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.

  • 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

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

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