SSIS "Execute SQL Task" - dynamic SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 พ.ย. 2024

ความคิดเห็น • 3

  • @antoniolupen6138
    @antoniolupen6138 10 หลายเดือนก่อน

    Where did you get the watch1 window? how did you configured it to display 'Name' and 'Value' ???
    Also , what would be the effect in the SQL server ? I see nothing happen. Thanks in advance

  • @kennethrosever8843
    @kennethrosever8843 3 ปีที่แล้ว

    This works but, am I correct that I can't put this in some kind of loop, where the target table and output columns may change on each loop, since the metadata is set at compile time?

  • @ishwetareddy
    @ishwetareddy 4 ปีที่แล้ว

    For me column name which is dynamic from a for each loop is not appearing in expression task. Any idea