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.
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.
Sometimes you need to pull data from an Oracle database into your SQL Server database. No magic is required, you just need to use a Linked Server. This article will show you how easy it is.