June 4, 2020 at 5:03 pm
I know I can do this using an OLE DB Command, but I was wondering if its possible to configure an ADO.NET connection and component as a destination?
EXEC dbo.WeatherForecastUpsert ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
If it isnt, no worries. I just cant seem to find a way to do it.
June 4, 2020 at 5:10 pm
One way you could do this would be to use a recordset destination then follow the data flow with a for each ADO.Net recordset loop. Then use an exec sql task to run the procedure and map the variables into input for the procedure.
June 4, 2020 at 6:11 pm
If you want a set of data to be processed by a stored procedure, could you simply load it into a staging table, then run the stored procedure to process those records as a set? Both your approach and ATW's approach seem to be row by row processing.
June 4, 2020 at 7:02 pm
I agree with Chris on this as well, just trying to give an option that fits with your current pattern.
June 4, 2020 at 7:03 pm
If you want a set of data to be processed by a stored procedure, could you simply load it into a staging table, then run the stored procedure to process those records as a set? Both your approach and ATW's approach seem to be row by row processing.
Agreed. This is, potentially, a far better approach.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply