Post reply

Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine.

  • January 4, 2012 at 12:13 am

    #248390

    Hi All,

    i am transfer the data Sybase to SQL that time i am getting problem where ever varchar(max) is there in database

    I am getting problem with varchar max getting problem in 64 bit operating system. I am not getting the problem wiht 32 bit machine. i am able to run the ssis package in 32 bit machine.

    I am using ADO NET Source task that time i am not getting above error.

    but same table i have two columns one column datatpe is Varchar (Max) another is sybase datatype is time

    I am not able to use same thing in one souces. one is supporting varchar(max) another is supporing time.

    Please look into this

    I am transfering the data sybase to SQL.

    Database DataType OleDB Source ADO NET Source

    Sybase Time Supporting NOT Supporting

    SQL DateTime NOT Supporting Supporting

    Sybase varchar(10000) NOT Supporting Supporting

    SQL Varchar(Max) Supporting Supporting

    But My case same table both the above data type columns are there. What need to be done for this.

    This problem is getting only for 64-bit machine only .. Pleaes advice me...

    Please help us what need to be done for this.

    Thanks & Regards,

    Venu

  • January 5, 2012 at 11:17 am

    #1429238

    I have not run into this myself, but... since things work on the 32 bit machine, is it possible you could import into 32 bit as a staging DB then transfer to your 64 bit machine?

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

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