Visual Studio集成服务-帮助查找项目 [英] Visual Studio Integration Services - Help with Lookup project

问题描述

我目前需要有关创建集成服务项目的帮助，这将使我能够根据缩写列表查找一个文本文件(逗号分隔)的值，然后生成固定"文本.值已更改的输出列表 以适合预期的格式.我是Visual Studio的新手，所以，如果可能的话，我需要一个简单的逐步指南，说明如何操作.

为了给出更好的主意，以下是我要执行的操作(清除数据)的示例:

    

Datawithissues.txt

产品，部门，成本

室外的鞋子20

Trainer，Outd，30

      

Abbreviations.txt

之前，之后

户外，室外

    

Result.txt

产品，部门，成本

室外的鞋子20

室外训练师30

解决方案

我没有得到逗号分隔的内容，但是在编程语言中，我们使用了许多点.

如果您有文本框，则可以放置任何想要的字符或符号.

所以我相信我可以生产出能够使之达到目标的东西

产品，部门，成本

培训师，Outd，30

但是我需要更多数据.

您能设计表格给我更多启发吗?

I currently need help on creating a integration services project which will allow me to lookup the values of one text file (comma separated) against a list of abbreviations and then produce a "fixed" output list where the values have been altered to suit the expected format. I am new to this part of visual studio so, if possible i need a simple step by step guide on how to do it.

In order to give a better idea here is an example of what i'm trying to do (clean data):

    

Datawithissues.txt

Product,Department,Cost

Shoe,Outdoors,20

Trainer,Outd,30

      

Abbreviations.txt

Before,After

Outd,Outdoors

    

Result.txt

Product,Department,Cost

Shoe,Outdoors,20

Trainer,Outdoors,30

解决方案

I didn't get the comma separated thing, but in programming language we use a lot of dots.

If you have textbox you can put any kind of character or symbol you want.

So I believe I could produce something that would give that 

Datawithissues.txt

Product,Department,Cost

Shoe,Outdoors,20

Trainer,Outd,30

But I need more data.

Can you design the form to enlighten me a little more?

这篇关于Visual Studio集成服务-帮助查找项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！