Solved

SSIS Package as ETL as Sybase as Source

Posted on 2009-05-13
2
736 Views
Last Modified: 2013-11-30
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..
0
Comment
Question by:KuldeepReddy
2 Comments
 
LVL 8

Expert Comment

by:tpi007
Comment Utility
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
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
Comment Utility
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql Stored Procedure 26 27
Database connection opened on a machine 8 26
SQL 2016 Setup - Connectivity Issues 4 11
Test a query 23 10
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now