Post reply

how to connect to sybase from SSIS and what all are software need to install

  • March 22, 2011 at 11:17 pm

    #247312

    Hi,

    I want to pass data from flat files to sybase by creating SSIS packages.For that what all are software need to install in my system.Can an y one help me.

    Thanks in Advance

    Venkat

  • March 22, 2011 at 11:54 pm

    #1302278

    for creating SSIS packages u need to install SQL Server 2005/2008/2008 R2 which has BIDS(Business Intelligence) inbuilt.... for connecting to sybase use OLEDB connection manager from SSIS packages......

  • March 22, 2011 at 11:59 pm

    #1302280

    Thanks, i need to keep sybase as my destination, so to work(support) on sybase ,which software i need to install.I heard that through "Rapid SQL" we can access sybase.Is it right?.or any other way is there? Please let me know.

  • March 23, 2011 at 4:08 am

    #1302353

    Ciber2010 (3/22/2011)

    Thanks, i need to keep sybase as my destination, so to work(support) on sybase ,which software i need to install.I heard that through "Rapid SQL" we can access sybase.Is it right?.or any other way is there? Please let me know.

    Sandeep has already given you all the information you need.

    Install the SQL Server client tools on the development machines, together with the SSIS engine.

    On the server, install SQL Server together with the SSIS engine.

    Regarding the connection, install the Sybase OLE DB driver on all machines.

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/bfbafbb9-c095-4250-9dc0-85f3731c9bda/

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 4, 2011 at 4:19 am

    #1306894

    I also installed Sybase SQL Advantage 12.5.1 to get better drivers.

Viewing 5 posts - 1 through 4 (of 4 total)

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