Post reply

Connectin to Sybase using SSIS

  • October 28, 2009 at 6:27 am

    #134949

    Hi,

    How could i connect to sybase using SSIS,

    Note my SSIS machine is 64-bit and i cannot find any OLE DB provider for sybase, (sybase is installed on 32bit machine).

    i need to extract data from sybase.

    I would prefer if get some OLE DB provider for sybase, but so far i didnt.

    Can any body help and illustrate steps in detail.

  • October 28, 2009 at 3:29 pm

    #1072124

    Well, connecting from SSIS will be as easy as connecting from any other application. You first need a data provider. So if you can't find an OLE DB data provider for Sybase, use ADO or ODBC.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • October 28, 2009 at 11:09 pm

    #1072240

    Jhon thanks for ur response.

    well i have only used so far OLE DB provider but didnt use ODBC, cannot you guide how to create ODBC connection for sybase, like data source and other stuff.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply