SSIS foreach组件循环遍历文件夹下文件并将数据插入到表 - XML源

发布时间：2020-12-16 22:59:08 所属栏目：百科来源：网络整理

导读：? Steps : ? Add variables : varFileFullName???? ????????? expression: @[User::varFilePath]+ @[User::varFileName] varFileName ????????????????????? default vaule : [file name] varFilePath???????????????????????? default value : [fiel path]

Steps :

Add variables :
1. varFileFullName???? ????????? expression: @[User::varFilePath]+ @[User::varFileName]
2. varFileName ????????????????????? default vaule : [file name]
3. varFilePath???????????????????????? default value : [fiel path]
4. set file folder and name use foreach container to get the file name one by one . ( * - wildcard character)

? ? ? ? ? ? ? ? ? ? ? ?

pass the file name to varFileName variables.

edit xml source? - XML file from variable.

loop get file name and do insert action file by file .

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!