The slides from the Using SQL Server Integration Services with Oracle talk from TechDays Hong Kong 2013 can be found below (use the embedded control to download the powerpoint presentation directly from SkyDrive). Thank you to everyone who attended!
When working with the Oracle Destination (the one from Microsoft/Attunity (2008 | 2012)), you might encounter generic data type conversion errors after mapping your columns. Validation error. Data Flow Task: Data Flow Task: Datatype conversion of Oracle Destination.Inputs[Oracle Destination Input].Columns[L_QUANTITY] is not supported. The error appears because there is not a 1:1 mapping of SSIS … Continued
I’ve been invited to the Microsoft Tech•Days event in Hong Kong next month – March 12th to 14th. This will be my first trip to Hong Kong, and I’m really looking forward to presenting to an international audience. I’ll be doing three SSIS related sessions: EIM – Bringing Together DQS, MDS and SSIS SSIS Performance … Continued
During my CDC presentation at TechEd North America I mentioned that the SSIS team would be posting a CDC for Oracle video, and I just realized I forgot to blog about it when it was announced on the SSIS team blog. Rakesh Parida (co-author on the SQL Server 2012 Integration Services book) this great video … Continued