SSIS中可能的运行时列传播？ [英] Runtime Column Propagation possible in SSIS ?
问题描述
我生命中的大部分时间都是数据分析员，所以请原谅我，如果我问一个愚蠢的问题。
要求：作为源的csv文件在不同日期可以有不同数量的列。
目前它有70列，但明天它可以有75列或60列。
我必须阅读csv文件并将其加载到表中。数据量也很大。
在数据存储中，我们有一个模式文件概念，它使我们能够在运行时传播列元数据。 / p>
是否可以在SSIS中指导或指导我如何处理上述情况的正确方向。
感谢您的帮助提前。干杯!!!!!
嗨 Magesh Udaya ，
我是否想知道您是否要在SSIS数据流任务中使用动态源和动态目标？
1.我们可以构建新数据Flow Task每天有一个源和一个目的地。
2.我们可以使用C＃以编程方式在SSIS包中创建数据流任务，以实现源和目标之间的动态映射。
最好的问候，
Mona Lv
Hi,
I am a datastage guy for most of my life, so pardon me, if i am asking a stupid question.
Requirement : The csv file which is the source can different number of columns at different dates.
Currently it has 70 columns, but tomorrow it can come with 75 columns or 60 columns.
I have to read the csv file and load it to the table. The data volume is also huge.
In datastage, we have a schema file concept, which enables us to propogate column metadata on runtime.
Is it possible in SSIS or can you guide me in a proper direction as to how to handle the above situation.
Thanks for your help in advance. Cheers!!!!!
Hi Magesh Udaya,
May I know if you want to use dynamic source and dynamic destination in SSIS Data Flow Task?
1.We could build a new Data Flow Task with one source and one destination every day.
2.We could Programmatically Create Data Flow Task in SSIS Package Using C# to realize dynamic mapping between Source and Destination.
Programmatically Create Data Flow Task in SSIS Package Using C#
Dynamic File Column mapping in SSIS.
Best Regards,
Mona Lv
这篇关于SSIS中可能的运行时列传播？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
