Tips
Execute PLSQL Code in an Oracle Package from SSIS
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 given that the various Oracle connection manager types don't support parameterized queries. Do you have any ideas?
Export SQL Server Data to Oracle using SSIS
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.
Oracle Parameterized Queries in SQL Integration Services 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 work in an SSIS package?
Top 10
Execute PLSQL Code in an Oracle Package from SSIS
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 given that the various Oracle connection manager types don't support parameterized queries. Do you have any ideas?
Export SQL Server Data to Oracle using SSIS
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.
Oracle Parameterized Queries in SQL Integration Services 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 work in an SSIS package?
Last 10
Export SQL Server Data to Oracle using SSIS
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.
Oracle Parameterized Queries in SQL Integration Services 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 work in an SSIS package?
Execute PLSQL Code in an Oracle Package from SSIS
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 given that the various Oracle connection manager types don't support parameterized queries. Do you have any ideas?
