当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server - variable from sql table and loop container

问题描述:

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

分享给朋友:
您可能感兴趣的文章:
随机阅读: