tags:

views:

844

answers:

1
+2  Q: 

Can you use Sybase.Data.ASEClient.dll .Net Provider with SSIS?

I am trying to create a data connection in SSIS. I have the Sybase.Data.ASEClient.dll version 1.1.680 installed but this does not show as a .Net Provider.

Is it possible to use this ADO.NET provider with SSIS and if so how can I make it accessible?

+1  A: 

I've never found a way to use it in SSIS either.

The option I use is the OLEDB connection that Sybase provides. The latest ones provided in the SDK are usable, although they do not approach the quality of the MS or Oracle OLEDB connectors.

AdamH  2008-11-06 10:07:53
Thanks for the info. OLEDB was my plan B.
Zach Cook  2008-11-06 10:16:49

related questions

Is there any way of reducing the dump file size of a Sybase database?
Testing for the existence of a temporary table in a multi tempdb environment?
Row number in Sybase tables
How can I get data from a stored procedure into a temp table ?
Avoiding TSQL Data-conversion errors
Sql Server 2005 SSIS unable to enlist SYBASE distributed transaction
Is there any thing such as SELECT LAST in sql query?
Aqua Data Studio - Shortcuts for Autocomplete
Difference between drop table and truncate table?
What is the list of JConnect error-codes?
Sybase Developer Needs To Learn Oracle
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
Unable to close OledbDataReader to Sybase Database in VB.NET
Any good SQL Anywhere database schema comparison tools?
Good books on Sybase ASE 15?
Case insensitive search on Sybase
How to convert a string to a date in sybase
Best use of indices on temporary tables in T-SQL
What is the difference between UNION and UNION ALL
Oracle equivalent to SQL Server/Sybase DateDiff
*= in Sybase SQL
Select Query on 2 tables, on different database servers
How do I avoid using cursors in Sybase (T-SQL)?
Best method for varchar date validation in Sybase (T-SQL)?
how to pass a comma separated list to a stored procedure?