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,