Excel目标中的动态映射 [英] dynamic mapping in excel destination

问题描述

大家好，
我是SSIS的新手，并且停留在一项功能上.
让我解释一下具体情况.
我有多个存储过程，并且所有过程都有一个select语句(当然，所有过程都返回不同的不同列).
我想使用类似"for each loop container"的东西，它将执行一个过程，获取结果数据并为这些数据创建excel文件.然后再次对下一个步骤进行相同的处理.但是这里的过程结果和excel目的地的映射存在问题.
我认为，这可能是常见的情况，所以有人已经做到了，但是在谷歌搜索时没有发现任何有趣的东西.
因为我是SSIS的初学者，所以请让我了解更多详细信息.

Hi guys,
i am new in SSIS and stuck with one functionality.
Let me explain exact scenario.
I have more than one stored procedures and all procedures have single select statement (ofcourse all procedures returning differnt different columns).
I want to use something like "for each loop container", which will execute one procedure, get result data and create excel file for those data. Then again same process for next procedure. But here mapping of procedure result and excel destination having an issue.
I thought, this might be a common scenario, so someone already done this, but didn''t found any interesting while googled.
Please let me know with more details as i am a beginner in SSIS.

推荐答案

映射在SSIS中始终是固定的，因此您不能进行动态映射.

Mapping is always fixed in SSIS, so you cannot have dynamic mapping.

这篇关于Excel目标中的动态映射的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！