SSIS-移动并打开zip文件/将xml文件加载到BD [英] SSIS - Move and open zip file / load xml file to the BD
问题描述
首先,您很了不起。
关于我的问题,我要做的是:
About my problem, what i have to do, is:
我在sftp中有一个包含多个文件(zip)的文件夹。
我需要做的是,从sftp加载这些文件,一个一个地加载到一个stagging文件夹,打开它们,里面有3个文件,2个pdf和一个xml。
我需要将xml上传到bd。
之后,基于xml(ExternalID)的一个字段,我需要将文件移动到某个文件夹中,这取决于ExternalID,在移动文件之前,我需要压缩所有3个文件并命名该zip文件
I have a folder in the sftp with multiple files (zip). What i need do do is, load those files from the sftp, one by one to a stagging folder, open them, inside they are 3 files, 2 pdf and one xml. I need to upload the xml to the bd. After that, based in one field of the xml (ExternalID) i need to move the file in some folder, that depends of the ExternalID, before i move the files, i need to zip all 3 files and name the zip with the ExternalID.
有人做过类似的事情吗?还是有人建议这样做?
Anyone did something similar? Or some advises to do this?
任何帮助将不胜感激。
致谢。
推荐答案
SSIS本身不支持SFTP。
SSIS doesn't support SFTP natively.
WinSCP(免费)可以方便。
这是它的链接:用于SSIS / SSDT的SFTP任务
WinSCP (free of charge) could be handy. Here is its link: SFTP Task for SSIS/SSDT
这篇关于SSIS-移动并打开zip文件/将xml文件加载到BD的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!