SSIS Package as ETL as Sybase as Source

Hi, Is there any tutorial/guidelines to use Sybase as a data source to create SSIS packages. We have a Requirement and our data source is on Sybase and we have to do some ETL and import them into Sql server.
I have tried but even I am unable to create Connection properties to Sybase from SSIS. Please help me..
KuldeepReddyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PedroCGDConnect With a Mentor Commented:
Just create a ADNO.NET connection in SSIS connection manager, add a Data Reader Source to your dataflow and configure it... is the way I read data from Sybase.
Regards,
Pedro
www.pedrocgd.blogspot.com
0
 
tpi007Commented:
This forum posting about connecting to Sysbase may help. See posting at bottom of page.
http://www.mydatabasesupport.com/forums/sqlserver-faq/228283-error-read-data-sybase-ssis-2005-a.html  
0
All Courses

From novice to tech pro — start learning today.