如何运行具有基于文件的源和目标的 SSIS 包 [英] How to run a SSIS Package which has a file based source and a target

问题描述

我有一个 dtsx 文件，我保存在我的桌面上.

I have a dtsx file which i saved on my desktop.

它抓取一个特定文件(源文件(CSV))并与另一个文件(目标文件(CSV)作为附加方式连接.我怎样才能运行这个 DTSX?我只想定期运行这个文件)不使用sqlserver，因为它与服务器无关.

It grabs a particular file(Source file (CSV)) and concatenate with the other file(Target file (CSV) as an appending manner . How can I run this DTSX? I just want this to be run on a regular basis without using sqlserver as it has nothing to do with the server.

我使用 sql server 2008 中的导入和导出数据向导创建了这个.

I created this using a import and export data wizard in sql server 2008.

推荐答案

您可以通过 DTEXEC 独立运行 SSIS 包，也可以通过双击包运行执行包实用程序"(DTEXECUI).

You can run SSIS Packages standalone via DTEXEC or by double clicking on the package to run the "Execute Package Utility" (DTEXECUI).

需要通过安装 SSIS和SQL/Server 工作站工具来安装这些工具.

These would need to be installed which you do so by installing SSIS and the SQL/Server workstation tools.

您也可以通过商业智能开发工作室 (BIDS) 执行此操作，不过这也使工作站能够修改包.

You can do this via the Business Intelligence Development Studio (BIDS) as well, though this would give the workstation the ability to modify the package as well.

这篇关于如何运行具有基于文件的源和目标的 SSIS 包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！