Multiple databases and SSIS - Sybase ASE OLE DB Driver
Scenario
Creating SSIS package to import data into SQL Server 2008 from Sybase ASE database. The ASE OLE DB connection uses a login that has access to multiple databases on the same server
Problem
Only one database was visible through SSIS even though the initial catalog was set up to use the second database
Resolution
Create a new SSIS project; Looks like SSIS cannot handle connections to 2 databases simultaneously!
Creating SSIS package to import data into SQL Server 2008 from Sybase ASE database. The ASE OLE DB connection uses a login that has access to multiple databases on the same server
Problem
Only one database was visible through SSIS even though the initial catalog was set up to use the second database
Resolution
Create a new SSIS project; Looks like SSIS cannot handle connections to 2 databases simultaneously!
Labels: multiple databases, SSIS, Sybase ASE OLE DB provider
posted by zatapatha at
11:14 AM
1 Comments:
Being a small Leeds business ourselves we, like you, cannot afford expensive software solutions to meet our needs. As such our business has developed automated solutions for business processes that are common to many small businesses
By
Ipad App Developers Leeds, at 1:16 AM
Post a Comment
<< Home