问题描述:

variable from sql table and loop container

I am trying to update active directory details into our companies staff_list table. Created ssis package to bring the data. I have done for one user (top 1) now struggling in loop. Have first name and last name to update other columns but can’t do in loop, if anyone pls help.

  • Have execute task which brings all firstname and lastname from

    staff_list table.

  • Then have script task to get staff loginID, designation, managername,phone etc.
  • Then have execute task which will update then details of user in table.

now I would like to update for all users with loop container if someone please help me with this. Thanks

相关阅读:
Top