0

I have an execute SQL task which is generating a result which I am storing in a variable

Result Set

then I am moving it into foreach loop Foreeachloop

Now what I am trying to do is the

result I got in Execute SQL task should be loaded into a table and I am using Data flow task for that in the foreach loop as there around 20 odd sever it will execute on.

Thanks

(This follows on from this question: How to pass table variable data into a data flow in ssis)

Community
  • 1
  • 1
Prav54
  • 3
  • 4
  • are you trying to cycle around different servers, get drive space on each server then save that in to a central table? It really helps to have background. – Nick.Mc Mar 03 '16 at 03:17
  • So are you getting an error? Stating what you want to do isn't a question. What is your question? – Tab Alleman Mar 03 '16 at 14:09

0 Answers0