﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Data Warehousing / Analysis Services  / Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine. / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Thu, 23 May 2013 07:39:26 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine.</title><link>http://www.sqlservercentral.com/Forums/Topic1229689-17-1.aspx</link><description>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</description><pubDate>Thu, 12 Jan 2012 08:53:03 GMT</pubDate><dc:creator>Mackers</dc:creator></item><item><title>Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine.</title><link>http://www.sqlservercentral.com/Forums/Topic1229689-17-1.aspx</link><description>Hi All,i am transfer the data Sybase to SQL that time i am getting problem where ever varchar(max) is there in databaseI 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 thisI 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 &amp; Regards,Venu</description><pubDate>Tue, 03 Jan 2012 23:44:11 GMT</pubDate><dc:creator>pkkrao1</dc:creator></item></channel></rss>