asked
Passing multiple records to SP in SSIS pacakge
I have 10 records in tabl1(id,name).I want to pass name to SP each time(10 records means.. 10 names) How can implement it in SSIS pacakge? Which transformtioncan can use? I know using "Execute SQL TasK" i can pass one variable each time and passign to SP. But multiple records( i mean here name) how can we pass it to SP(each iteration)?
Add LOOP container and have Execute SQL Task inside it.
Create a Data Flow with eg. OLE DB Source reading your data from a table. Then connect it to OLE DB Command in which you will call the stored proc and map the parameters of the Stored proc.
