Researching SQL Server Integration Services Oracle issues? Check out these valuable tips, tutorials, how-to’s, scripts, and more perfect for SQL Server BI Professionals.
An Oracle Package is similar to a SQL Server SQL Server Stored Procedure. If you want to run an Oracle Package and then execute a web service, copy files or folders, a sequence of tasks, etc. you may need to use SQL Server Integration Services (SSIS). SSI
I have some SQL Server data that I need to export and load into an Oracle database. In this tip we cover how this can be done with SSIS.
I have a number of DTS packages that I want to rewrite to use SSIS. One problem I have is that these packages make use of the ActiveX Script task in order to run parameterized queries against an Oracle database. Any ideas on how best to convert these to
We have a number of Oracle stored procedures that we need to execute from an SSIS package. The PL/SQL code is deployed in various Oracle packages. Many of these stored procedures require parameters and we're struggling to find the best way to do this gi