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

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 03, 2014 3:41 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 11, 2014 3:27 AM
Points: 77, Visits: 488
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