question

SQLDBA123 avatar image
SQLDBA123 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)?
ssispackagesp
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

alexsdba avatar image
alexsdba answered
Add LOOP container and have Execute SQL Task inside it.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.