none
SSIS

    Dotaz

  • hello

    I have a table 'Test' in sql server with following columns

    |path       |Name| Table name|

    |C:\Test1 |x.txt | Test1         |

    |C:\Test2 |y.txt |Test2          |

    |C:\Test3 |a.txt |Test3          | 

    |C:\Test4 |b.txt |Test4          |

    My task is to read this table from sql, loop through each row and get complete path of file and load data from each file to corresponding table. All the tables have same structure. 

    This is solved now.

    Regarding this task I now have another table which contains packagename, taskname, start_datetime, end_datetime, no. of rows downloaded from source, no. of rowinserted and no. of rows updated.

    I need to insert into this table with corresponding values after each iteration of foreach loop. How can I do this??

    čtvrtek 12. července 2018 9:46

Všechny reakce

  • Hi evati_k,

    Thanks for posting in SSIS forum.

    Please have a check your another thread: SSIS

    And please avoid posting duplicate thread for same question.

    Also please mark appropriate replies as answer if someone's replies resolved your issue.

    Thanks for your understanding and support.

    Regards,

    Pirlo Zhang 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Navržen jako odpověď Olaf HelperMVP pátek 13. července 2018 5:29
    pátek 13. července 2018 2:33