I have to load files into a table using loop in SSIS 2008 .. Also need to track each process into a 'process_track' table containing the fields Process_id, Start_time, End_time and Status (processing or completed) .. How can I do this ? Thanks in advance ...
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
In broad strokes, you want a for loop in your control flow, which will manipulates a variable that you can use in an expression that determines the connection string of your flat file connection manager. In the for loop, have a data flow task that moves your data around, as well as an 'execute sql statement' task which writes an update to your process_track table.
