sql server - SSIS return value of Stored Procedure within an OLE DB Command -


I am migrating data that must be entered using stored procedures that already exist. The stored procedures contain the parameters of the id for the rows and a return value (from a selection statement). Within an OLE DB command in SSIS, I can call the stored procedure passing the column values ​​in the form of parameters, and I usually use the output parameter on the stored procedure to handle the "id" output; But I am unsure how this can be controlled with return values ​​when the process uses the selection to use an ID. Here's an example I used to use before, but before I was chosen: 

  exec dbo.uspInsertContactAddress @Address = ?, @ContactID = ?, @ DeliveryMethodId = ?, @ID =? Output, @ version =? The way I found that I could do that was really simple:  
  Exec? = Dbo.StoredProc @ param = ?, @best =?  
 
 and then a @RETURN_VALUE will appear at the Available Destination column

Comments

Post a Comment