CallConnection
asked on
Using OLE DB Command to insert into a parameterised stored procedure
Hi Experts
I have an ETL task that uses the dataflow component OLE DB Command. I have 24 inputs which I'd like to map to a parameterised stored procedure.
e.g. I specify a sql command of
exec dbo.InsertCustomer @id=?,@name=?,@email=?....
However when I try and include >20 of the available input columns I hit an error "Invalid parameter number". In the column mapping tab I only ever see the first 20 destination parameters.
How can I workaround this in SSIS?
Thanks in advance
I have an ETL task that uses the dataflow component OLE DB Command. I have 24 inputs which I'd like to map to a parameterised stored procedure.
e.g. I specify a sql command of
exec dbo.InsertCustomer @id=?,@name=?,@email=?....
However when I try and include >20 of the available input columns I hit an error "Invalid parameter number". In the column mapping tab I only ever see the first 20 destination parameters.
How can I workaround this in SSIS?
Thanks in advance
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER