Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by juanthompson
-
Execute oracle stored procedure from DTS (no parameters)
Here's what I'm doing: Have an OLEDB data source (Using the Oracle-provided OLEDB driver, not the MS version). Have an Execute SQL Task. That task contains: BEGIN CMG_PS_STAGING_LOAD.LoadPayrollJEFromStagingToGL; END; This works fine when I execute it in Oracle directly, but fails when I...- juanthompson
- Post #7
- Forum: Microsoft SQL Server: Data Transformation Services
-
Execute oracle stored procedure from DTS (no parameters)
I have the same issue, and I would love to know if you have found a solution to it. I am trying to call a stored procedure on an Oracle database from SQL Server 7 DTS. Any suggestions would be greatly appreciated. Juan- juanthompson
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
