[ODBC Sybase ASE driver][SQL Server]Incorrect syntax near '['.

[baalbaal]

In SSIS VS 2005 I added a data source for Sybase, when I'm trying to add a table to the Data Source View I get a list of available tables, once I select a table and click OK I get the following error:


ERROR [42000] [MERANT][ODBC Sybase ASE driver][SQL Server]Incorrect syntax near '['.

Same goes if I try to add a Named Query.

Are there are any settings I can change so that SSIS doesn't use square brackets when it generates a query?

I'm using older Sybase driver, but thats all I got for now.

Thanks.


More details:

ERROR [42000] [MERANT][ODBC Sybase ASE driver][SQL Server]Incorrect syntax near '['.
(SYODASE.DLL)

------------------------------
Program Location:

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcDataReader.get_FieldCount()
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.get_VisibleFieldCount()
at System.Data.ProviderBase.DataReaderContainer.Create(IDataReader dataReader, Boolean returnProviderSpecificTypes)
at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
at System.Data.DataTable.Load(IDataReader reader)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV()