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 2005 Forums
 Other SQL Server Topics (2005)
 Create ODBC Dest Connec to Sybase in SQL BIDS 2005

Author  Topic 

5ha66y
Starting Member

2 Posts

Posted - 2010-11-22 : 14:26:14
I have been working on a project in SQL Server 2005 BIDS and have been unable to create an destination connection to a Sybase DB. I can set up a ODBC connection in Connection Manager just fine and it tests out perfectly, however there is no object in the toolbox that will let me create a destination. There is an option for ODBCConnection but it is grayed out. I have even run the devenv /ResetSkipPkgs command as I saw posted on another site hoping that would work, but it does not enable that option. Any help on this would be greatly appreciated.

5ha66y
Starting Member

2 Posts

Posted - 2010-12-08 : 17:14:46
Perhaps it would be easier if I was able to obtain an OLE DB driver for the outdated Sybase 11. Can anyone provide assitance with that? Please let me know. Thank you.
Go to Top of Page
   

- Advertisement -