将所有 DTS 包导出到文件系统的脚本 [英] Script To Export All DTS Packages ON IS To File System

问题描述

是否有脚本可以将集成服务服务器上的所有 DTS 包导出到一个文件系统路径(即:C:\DTSPackages)?目前，如果存在脚本，右键单击、选择导出、选择文件系统的任务似乎有些多余，但我发现的所有内容都是显示存在哪些包的脚本(不重要).

Is there a script that will export all DTS packages on an Integration Services Server to one file system path (ie: C:\DTSPackages)? Currently, the task of right clicking, selecting export, choosing the file system seems somewhat redundant if a script exists, yet all I've found are scripts to show what packages exist (unimportant).

谢谢.

推荐答案

您可以使用 DTUTIL 实用程序来编写包移动的脚本:

You could use the DTUTIL utility to script movement of packages:

http://msdn.microsoft.com/en-us/library/ms162820.aspx

以下是从 SQL 移动到文件的示例:

Here is an example of moving from SQL to File:

http://www.bimonkey.com/2010/01/ssis-command-line-utilities-part-1-dtutil/

以下是一些用于枚举 MSDB 中包的脚本:

Here are some scripts to enumerate packages in MSDB:

http://blog.hoegaerden.be/2010/01/10/list-all-ssis-packages-deployed-on-your-integration-server/

http://gallery.technet.microsoft.com/scriptcenter/List-all-SSIS-packages-3b247394

最后，您可以运行一个 SQL 查询来生成 dtutil 调用，然后您可以将其通过管道传输到批处理文件中.请参阅 从 msdb 中提取 ssis 包

Finally, there's a SQL query you can run to generate the dtutil calls which you can then pipe into a batch file. See ssis package extract from msdb

如果您需要一些帮助，请告诉我.除非我知道 OP 正在参与，否则我不会在这里做太多努力.

If you want some help sticking it all together let me know. I don't make much effort here unless I know the OP is engaged.

这篇关于将所有 DTS 包导出到文件系统的脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！