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=?.... etc etc
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