Calling Oracle SP from SSIS

• josefrancis

  SSC Enthusiast

  Points: 150

  More actions

  October 9, 2008 at 2:04 am

  #126956

  Hi,

  I want to load data using an oracle stored procedure to a SQL server database. How can we proceed. I tried different combination. But nothing worked out for me. Any help will be greatly appreciated.

  Thanks

  Jose

• PeterHmoodang

  SSC Enthusiast

  Points: 175

  More actions

  October 9, 2008 at 3:52 am

  #882776

  Do you create datasource that use the Oracle provider?