In my case, I cannot change the parameters of a stored procedure because those stored procs are created by the ERP system and code locked.

However, I would take the...

Hi-

EXEC dbo.Test1 @Key1 = ?, @Key2 = ?

This will work if I use both parameters, In my case I only want to send values for second parameter alone.

On this...

I wouldn't be changing the Command. Can I get the syntax for using the named parameter in the Oledb command?

Hi there-

The stored procedure is locked and it is from the corresponding ERP system.

I found an alternate way to do this by using OLEDB Command. But I have one other...

So what controls in the Dataflow I should use to get this done?

Thanks

My staging table will have all the records that needs to be imported in to a ERP system with the status flag set to 0. And this Staging table is...

Hi Jack Corbett-

I have the same requirements to be done in SSIS.

That is, I need to loop thru all the records in a staging table and call a...