Hi, I'm currently attempting to execute a stored procedure from a SQL Server DB in monarch's datapump, then export the results to monarch, but I'm not sure if the script should be put under the pre-export or post-export tab.
We are using Datapump 10.5
Here's the script:
*On the References and Imports tab,
*Not sure if the following would go under the pre or post processing tab
' Set up Connection object and Connection String for a SQL Client
Dim SQLCon As New SqlClient.SqlConnection
SQLCon.ConnectionString = "Data Source=DSlifeproqa;Initial Catalog=LifePro;Integrated Security=sspi;"
'Set up command object and properties
Dim SQLCmd As New SqlClient.SqlCommand
SQLCmd.CommandText = "dbo.usp_310REPORT" ' Stored Procedure to Call
SQLCmd.CommandType = CommandType.StoredProcedure 'Setup Command Type
SQLCmd.Connection = SQLCon 'Active Connection
Catch ex As Exception
' Do what you need to here or don't have it do anything
' Dispose objects for garbage collection