Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
pkkrao1
pkkrao1
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 63
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
Mackers
SSC-Enthusiastic
SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)SSC-Enthusiastic (117 reputation)

Group: General Forum Members
Points: 117 Visits: 499
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search