Friday, March 9, 2012

How to create a connection into Sybase Database

Hi, i already create a connection to sybase(ASA) with odbc from ssis (from "data sources" section). but when i try to make data flow source it cann't. so i try to make a connection using "data source views" but when the process comes to end, it becomes error. from my analysis, the Sybase db cannot accept sql command with "[]", because in the fase "data source views" i have to select one or more table, and the default microsoft is using "[]", like: select * from [dbo].[customer], but sybase db cannot handle this. does anyone have the solution for this? Thanks.

Sincerely

Yugicm

I am not clear why you need to use a DSV. If you just entered the SQL into the source it should work. You can then choose the syntax required.

If using the OLE-DB Source, look at the Access mode option, and try "SQL command". This allows you to manually enter the SQL which is often a better idea anyway. Specifying columns is good practice, and generally results in faster packages as you can reduce the amount of data you extract and then handle in the pipeline.

No comments:

Post a Comment