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!!!!!