Moving data from SybaseIQ tables to sqlserver using SSIS.

Question

Post reply

Moving data from SybaseIQ tables to sqlserver using SSIS.

chakrirajini

Valued Member

Points: 67
More actions
March 30, 2013 at 7:54 am

#147975

Hi,
Can any one help me to load the data form SYBASEIQ to sqlserver using ssis.
1. where do I get the OLEDB driver for SybaseIQ(direct link) ?
2. How to use this from SSIS .
I know SSIS very well but i am new to Sybase Environment.
Thanks in advance

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

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

Paul Hernández SSCarpal Tunnel Points: 4961 More actions · Answer 1

Hi,

Just Googling a Little bit:

Creating SSIS Project with Sybase IQ 15.2 using OLEDB Connection

Please tell us if that works.

Kind Regards,

Paul Hernández

tmitchelar Hall of Fame Points: 3391 More actions · Answer 2

You need the iSeries Access for Windows installed. This will provide you with the data provider to connect to AS400 through SSIS. It will give you the option in the drop down once this has been installed.