Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine. Expand / Collapse
Author
Message
Posted Tuesday, January 03, 2012 11:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 29, 2013 2:29 AM
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
Post #1229689
Posted Thursday, January 12, 2012 8:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
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
Post #1234922
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse