Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 How can we connect sybase database

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2011-08-02 : 09:01:44
Hi expert

i have sybase data source
how can i connect that database by using oledb datasouce
please help in this


thanks in advance

flamblaster
Constraint Violating Yak Guru

384 Posts

Posted - 2011-08-02 : 09:07:05
I don't have an answer for you, but we're trying to do the same thing with an old version of Sybase. Have you looked into MS SQL Server Migration Assistant? It also sounds like there may be some tools in SSIS as well as 3rd party software such as Informatica, but we're still in the investigative stage. I'm anxious to see how your project goes.
Go to Top of Page

boreddy
Posting Yak Master

172 Posts

Posted - 2011-08-02 : 09:14:24
we are having so many data sources
like oracle and sql server.....etc

we have threre data souces DB are in sybase
we can't use any other tools, we have to use ssis only
please suggest any other option for this
this very urget for me

thnaks once again

Go to Top of Page

flamblaster
Constraint Violating Yak Guru

384 Posts

Posted - 2011-08-02 : 09:17:00
Well MS SQL Server Migration Assistant is part of SQL Server Management Studio and/or SSIS from what I understand; you just have to activate and/or download it.
Go to Top of Page

boreddy
Posting Yak Master

172 Posts

Posted - 2011-08-02 : 09:50:01
could please give some more information regarding this

i am new to that
Go to Top of Page
   

- Advertisement -