Sybase Driver for SSIS

did you tried this provider from sybase own products?:
http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/net-data-provider

Hi

Reza_rad, thanks alot, i am testing it now, just installed it, i will get back to you soon

hi Reza_rad

the (Advantage Database Server is a complete, high performance client/server data management solution for standalone,
networked, and Internet database applications. Advantage allows application developers the flexibility to
combine powerful SOL statements and relational data access methods with the performance and control of
navigational commands. Advantage has native development interfaces designed to leverage developers’ existing
knowledge of popular development tools. Using optimized data access, Advantage provides security, stability, and
data integrity with zero administration.)

its not a driver that i can use to connect to Sybase database, i am trying to use SSIS to connect to sybase and read sybase tables.

>>its not a driver that i can use to connect to Sybase database, i am trying to use SSIS to connect to sybase and read sybase tables.<<
you can add a data flow task,
and inside data flow task, add OLE DB SOURCE , and in ole db source, choose sybase connection type ( for this you need a database driver , like what i suggested )
and then you can read data from this source, and do any transformation you want.

now let me know:
do you have problem in connection ?
or you have problem in the transformation to implement logic ?

Thanks Dear

now you know that if you are using microsoft SSIS and you try to fetch data from oracle or sybase or DB2 or what ever, you need drivers, to connect to these different DBMSs.

in my case i am trying to connect to sybase.
so i tried all, and i mean all sybase drivers that are on their website, and i read alot in this issue. you can see its also mentioned here https://www.experts-exchange.com/questions/23944427/how-to-connect-to-sybase-with-SSIS.html

but none, no sybase driver was working fine with me, i always get errors

but with DataDirect i was able to connect to sybase and it was amazing and fast. my only problem with datadirect, is its very expensive.

All am looking for is something similar to datadirect but with lower price.

I haven't experience with any sybase data provider before,
so I can not help you more on this issue,
but you can google more free data providers , maybe one of them be as good as you want.

Thanks alot any way for your trying, i spent alot of time searching for this driver and i think i dont have alot of choices, i will continue searching.

thanks very much Chris

you are right this is an option, but in my case i am keeping it as the last, only if i am unable to solve it technically then i will use your option because it requires some meetings and decisions from the other departments as well.

i was able to read from sybase using sybase driver 12 on a sql 2000, with the help of DTSs, now we decided to upgrade to SQL 2008, and so we are going to upgrade all our DTSs to SSIS as well, we wil redevelop it all.

but couldn't fine a good driver other then DataDirect.

Any way i will give this issue few more days and see, other wise as you said, i will have to go for flat files.

Regards

Are aany of your servers 64 bit? this can cause issues with drivers.
Do you want to post some of the error messages that you get?
Is it Sybase ASE or Sybase IQ that you are getting data out of ? What version? Can you get the driver to 'test' OK using the driver tools?

hi nmcdermaid:

attached is a word document which explains my problem in images, you can see the error message.

in this senario, i am using win2003 server 32bit, SQL 2008, SSIS and Sybase Adaptive server Enterprise (ASE) 15.0.2.

i have another server which is Win 2003 64 bit, but i havent used it yet, i am still unable to get it to work with the 32-bit

hi nmcdermaid:

attached is a word document which explains my problem in images, you can see the error message.

in this senario, i am using win2003 server 32bit, SQL 2008, SSIS and Sybase Adaptive server Enterprise (ASE) 15.0.2.

i have another server which is Win 2003 64 bit, but i havent used it yet, i am still unable to get it to work with the 32-bit
Sybase-Driver-Errors.docx

1. Don't bother trying to browse tables. Definitely stick to using the SQL Command access mode.
2. I never use the SSIS. I always build it from scratch - it's not that hard.
What exact error do you get when you use the free Sybase driver and it fails?

thats the main error message you saw.

but other wise, i cant use the import export wizard and it doesnt show any error, and i cannot view the tables.

my problem is i have more then 50 tables that i want to read from sybase and in each table i have 100+ columns

doing it manually means i will have to do the conversion of data types manually, and it takes nearly 4-5 hours for each table. just repeated tedious work.

thats why i wanted to use the wizard, the wizard will bring all the tables i need and will do the datatype conversion all automatic.

SSIS is not like DTS, DTS is much simpler when you are doing a direct copy from one table to another, but in SSIS you have to manually do the datatype conversion, which takes lots of time.

Conversion of data types is almost inevitable since the two systems are different.what gives you the best results.
Please be careful with columns which have special characters like commas, quotes etc.

Thanks To all who participated, i got few good ideas

but until now , i didnt get a solution to my main problem .

i didnt find any good driver,

i think i am between 2 options

1. do what pastorchris: suggested, or
2. buy the expensive driver from Datadirect.

It wasnt a solution to my main problem, but its another option to get things done.

i would really prefer a driver just kike datadirect.