SQLTeam.com | Weblogs | Forums

SSIS to import xml to Oracle 11 db


We are an Oracle shop but are in the process of converting to Microsoft. Is it a good idea to use SSIS to pull in XML files and use to import or update the Oracle database. Some say we should use C# i think that since we have sql server/ssis and plan on completely converting to that platform we should use ssis. Any advice would be appreciated. Mark


I wouldn't bother with XML files - unless that is the only way you can get access to the Oracle data. I would use ODBC to connect directly to Oracle and use SSIS to extract and load the data into SQL Server.