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

• pkkrao1

  SSC-Addicted

  Points: 444

  More actions

  January 3, 2012 at 11:44 pm

  #149779

  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

• Mackers

  SSCrazy

  Points: 2935

  More actions

  January 12, 2012 at 8:53 am

  #1432603

  My guess would be driver issues.

  You could run SSIS as 32bit (even on a 64 bit machine). I do this on my load to get around 64-bit driver issues