Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Connecting to Sybase tables through SSIS 2005 for use in reference tables and repository Expand / Collapse
Posted Tuesday, March 23, 2010 6:29 AM


Group: General Forum Members
Last Login: Tuesday, March 23, 2010 10:25 AM
Points: 10, Visits: 16
We are in the process of implementing a new procedure whereby we take client flat files, perform transformations on the data using both derived functions as well as reference tables. The reference tables and end table are all Sybase tables. When we attempt to map the reference tables or the end table to the process it gives us an error which out IT team has said occurs because SSIS is adding an additional "dbo." to the front of the table4 names.

Has anyone had any success linking Sybase tables as reference tables in lookups and also as the repository for the end data? If so, please help!!!!!
Post #888034
Posted Friday, January 3, 2014 3:41 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 24, 2016 2:55 AM
Points: 96, Visits: 561
Have you seen if there are any settings in the driver you use to connect to Sybase? It could be a feature of the driver when you connect.

Post #1527432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse