Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving data from SybaseIQ tables to sqlserver using SSIS. Expand / Collapse
Author
Message
Posted Saturday, March 30, 2013 7:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 1:00 AM
Points: 2, Visits: 35
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
Post #1437199
Posted Tuesday, April 2, 2013 5:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:46 AM
Points: 115, Visits: 472
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
http://hernandezpaul.wordpress.com/
https://twitter.com/paul_eng
Post #1437840
Posted Tuesday, April 2, 2013 12:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 2:17 PM
Points: 124, Visits: 485
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.
Post #1438052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse