SSIS中的动态列映射 [英] Dynamic Column Mapping in SSIS

问题描述

我有SSIS包，它将excel文件导入到每周更新的sql表。我创建了一个包含excel source和sql destination的包。它工作正常，但问题是excel列有时被删除/添加，并且列重新命名。有没有什么方法可以自动映射自己而不是每当我的Excel列更改时手动映射ssis包？

请帮助



谢谢

i have SSIS package where it imports excel file to sql table that is updated weekly. I created a package where it has excel source and sql destination. It works fine but the problem here is the excel columns gets deleted /added sometimes and also the columns gets re-named. Is there any way that i can automate it to map itself instead of manually mapping the ssis package whenever my excel columns changes?
please help

Thanks

推荐答案

您好，



您如何确定现有列的新名称？我想你需要指定一些。



这似乎与列的动态映射有关，你可以在google上找到这方面的帮助。



问候，

Mubin

Hi,

how can you decide what is new name of the existing column? I think some where you have to specify this.

this seems relevant to dynamic mapping of columns, you can find help on this in google.

Regards,
Mubin

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