J
john_thurgood
Guest
Hi Sumit, I have Sybase ASE server source and a SQL Server 2012 destination. I'm wanting to bulk copy 90GB of data from 300 tables using the DataDirect ODBC drivers for Sybase and SQL server to complete the task. Using the drivers via the native ODBC provider in SSIS is extremely fast, however building the packages is not because the SSIS Import/Export Wizard doesn't seem to expose the provider, and a Data Flow Task can't be re-used dynamically. Is there an easier way to achieve this (and maintain performance) rather than creating SSIS Data Flow Task source/destinations for each table?
Continue reading...
Continue reading...