使用 SSIS 2008 中的循环将文件加载到表中 [英] load files into a table using loop in SSIS 2008
问题描述
我必须在 SSIS 2008 中使用循环将文件加载到表中..还需要将每个进程跟踪到包含字段 Process_id、Start_time、End_time 和 Status (processing or completed) 的process_track"表中.我该怎么做?提前致谢...
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 ...
推荐答案
概括地说,您需要在控制流中使用 for 循环,该循环将操作一个变量,您可以在表达式中使用该变量来确定您的连接字符串平面文件连接管理器.在 for 循环中,有一个移动数据的数据流任务,以及一个将更新写入 process_track 表的执行 sql 语句"任务.
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.
这篇关于使用 SSIS 2008 中的循环将文件加载到表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!