动态调用子包到父包 [英] dynamically call child packages into parent package

问题描述

我有不同的发票文件格式（XML，CSV和Excel）。我需要将这些文件中的数据加载到数据库中，我正在为每个文件使用子包。是否有可能动态调用子包进入父包并根据文件格式执行每个包？

I have different invoice file formats (XML, CSV and Excel).I need to load the data in those files into database, I am using child packages for each file. Is there any possibility to dynamically call child packages into parent package and execute each package based on the file format?

推荐答案

是的你可以创建主要主包，你必须选择你的文件并首先检查文件类型，然后在第一个任务中将类型设置为变量



然后在较低级别，您可以使用创建3个不同的序列容器，其中3个包控制流的包执行任务指向3个不同的包以供执行。



在Prcedence constrating place expression中检查文件的类型，在此基础上你可以决定执行哪个分支。



此链接将帮助您



http://technet.microsoft.com/en-us/library/ms140153.aspx





如果您有任何疑问，请告诉我。



问候，

Mubin

Hi ,

Yes you can Create Main Master Package, In which you have to select your file and first check type of file and then set type into variable in first task

Then at lower level you can use create 3 different sequence container with 3 package execution task of control flow pointing to 3 different packages for execution.

In Prcedence constrating place expression to check type of file and on the bases of this you can decide which branch to execute.

This link will help you

http://technet.microsoft.com/en-us/library/ms140153.aspx


please let me know if you have any query.

Regards,
Mubin

这篇关于动态调用子包到父包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！