SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

Calling an Oracle stored procedure in SSIS is a little different than calling a SQL Server version.  Today I will show you the error you get if trying the SQL Server syntax and how to fix it.

Continue reading SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

Speed up Linked Server Connection To Oracle using OPENQUERY

Last time I showed how to create a connection to an Oracle database by creating a Linked Server in SQL Server.  Most of the time this works fine, but when you are pulling a lot of information, it tends to run slow.  By using OPENQUERY, the query will run very, very fast.

Continue reading Speed up Linked Server Connection To Oracle using OPENQUERY