如何在SSIS(集成服务)中串联2个文件? [英] How to concatenate 2 files in SSIS (Integration Services)?

问题描述

我有2个文件没有相同的列.我希望能够将它们连接起来，但是我似乎找不到找到这种方法的方法.我曾考虑过使用脚本组件，但是仍然希望您声明输出列.

I have 2 files that do not have the same columns. I want to be able to concatenate them, but I can't seem to find a way to do this. I thought about using a Script Component, but that still wants you to declare output columns.

第一个文件具有如下列和数据:

The first file has columns and data like this:

A|B|C|D|E|F|G
Adata1|Bdata1|Cdata1|Ddata1|Edata1|Fdata1|Gdata1
Adata2|Bdata2|Cdata2|Ddata2|Edata2|Fdata2|Gdata2
Adata3|Bdata3|Cdata3|Ddata3|Edata3|Fdata3|Gdata3
Adata4|Bdata4|Cdata4|Ddata4|Edata4|Fdata4|Gdata4

第二个文件具有如下列和数据:

The second file has columns and data like this:

H|I|J|K|L|M|N
Hdata1|Idata1|Jdata1|Kdata1|Ldata1|Mdata1|Ndata1
Hdata2|Idata2|Jdata2|Kdata2|Ldata2|Mdata2|Ndata2
Hdata3|Idata3|Jdata3|Kdata3|Ldata3|Mdata3|Ndata3
Hdata4|Idata4|Jdata4|Kdata4|Ldata4|Mdata4|Ndata4

我需要整个输出文件如下所示:

I need the overall output file to look like this:

A|B|C|D|E|F|G
Adata1|Bdata1|Cdata1|Ddata1|Edata1|Fdata1|Gdata1
Adata2|Bdata2|Cdata2|Ddata2|Edata2|Fdata2|Gdata2
Adata3|Bdata3|Cdata3|Ddata3|Edata3|Fdata3|Gdata3
Adata4|Bdata4|Cdata4|Ddata4|Edata4|Fdata4|Gdata4
H|I|J|K|L|M|N
Hdata1|Idata1|Jdata1|Kdata1|Ldata1|Mdata1|Ndata1
Hdata2|Idata2|Jdata2|Kdata2|Ldata2|Mdata2|Ndata2
Hdata3|Idata3|Jdata3|Kdata3|Ldata3|Mdata3|Ndata3
Hdata4|Idata4|Jdata4|Kdata4|Ldata4|Mdata4|Ndata4

我知道这与众不同，但这就是要求...

I know it's out of the ordinary, but that's the requirements...

有什么建议吗?

推荐答案

执行脚本任务.如果您有3个文件的连接管理器，则无需对该任务进行任何输入.

Go with a script task. If you have connection managers for your 3 files, you don't need any inputs to the task.

使用以下命令访问连接字符串:

Access the connection strings with:

var fileAString = Dts.Connections["fileAConnectionManagerName"].ConnectionString;

工作流程可以，打开fileC进行写入.打开fileA进行读取.读取数据并写入fileC.关闭文件A.打开fileB进行读取.读取数据并写入fileC.关闭文件并返回成功.

Workflow can be, open fileC for write. Open fileA for read. Read data and write to fileC. Close fileA. Open fileB for read. Read data and write to fileC. Close files and return success.

这篇关于如何在SSIS(集成服务)中串联2个文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！