He all,
I wish to loop one SQL code like EXEC [dbo.MyStoreProc] '\\mypath\myfile\'
the value of \\mypath\myfile\ is the file name found with the task list File(s).

That is the task sequence as I think to be:
list File(s)
In the task SQL I set the loop as for each row in {TASK(PrevTask|StdOut)}

so how I can pass the filenalme at SQL code?
EXEC [dbo.MyStoreProc] '\\mypath\myfile\' {TASK(PrevTask|StdOut)}(x) ?

thank
Fabrizio

exec [dbo].[PALLETSCAN_Test] '\\MYPATH' \ '{LOOP(CurrentValueXArray|0)}

I get on error : Incorrect syntax near \, but I think to have found the solution,

exec [dbo].[PALLETSCAN_Test] '\\MYPATH' \ '{LOOP(CurrentValueXArray|0)}

I get on error : Incorrect syntax near \, but I think to have found the solution,

Great, do you still need help or did you find a solution?

---

Hi Michael,
thank I found the solution, to share it at who can be need:
exec [dbo].[PALLETSCAN_Test] '\\MYPATH\{LOOP(CurrentValueXArray|0)}'


ps: How I can mark as solved this thread??

Hi Michael,
thank I found the solution, to share it at who can be need:
exec [dbo].[PALLETSCAN_Test] '\\MYPATH\{LOOP(CurrentValueXArray|0)}'


ps: How I can mark as solved this thread??

Thank you! No need to mark anything. We just consider it closed.

---