SQL Server在哪里存储DTS包？

I have created a few DTS packages and saved them on the server. where I can edit these DTS packages on the server?

我创建了一些DTS包并将它们保存在服务器上。我可以在服务器上编辑这些DTS包吗?

4 个解决方案

#1

you should connect to integration services... and then in the MSDB folder or in the FileSystem folder, it depends how did you save them

您应该连接到集成服务...然后在MSDB文件夹或FileSystem文件夹中,它取决于您是如何保存它们的

#2

As you probably know, DTS was deprecated and was replaced by SSIS in SQL Server 2005. It IS possible to edit and run DTS packages in SQL Server 2005 however, by installing the “Feature Pack for Microsoft SQL Server 2005”. Particular components that you should look at are “Microsoft SQL Server 2000 DTS Designer Components” for editing and “Microsoft SQL Server 2005 Backward Compatibility Components” for the runtime.

您可能知道,DTS已被弃用,并在SQL Server 2005中被SSIS取代。但是,可以通过安装“Microsoft SQL Server 2005功能包”来编辑和运行SQL Server 2005中的DTS包。您应该查看的特定组件是用于编辑的“Microsoft SQL Server 2000 DTS Designer组件”和用于运行时的“Microsoft SQL Server 2005向后兼容组件”。

This allows you to upgrade from SQL Server 2000 to SQL Server 2005 and your old DTS packages will still run. This leaves you time to upgrade them to SSIS.

这允许您从SQL Server 2000升级到SQL Server 2005,您的旧DTS包仍将运行。这使您有时间将它们升级到SSIS。

#3

When you use the Import/Export wizard you are given an option, at the end of the wizard, to save the SSIS package into the database.

使用“导入/导出”向导时,将在向导的末尾为您提供一个选项,以将SSIS包保存到数据库中。

The wizard saves the package in the msdb database in the sysssispackages table. This option does not save the package to the SSIS Catalog database (SSISDB).

该向导将包保存在sysssispackages表的msdb数据库中。此选项不会将程序包保存到SSIS目录数据库(SSISDB)。

#4

The raw payload of a DTS package should give results from this:

DTS包的原始有效负载应该得到以下结果:

SELECT * FROM msdb.dbo.sysdtspackages WHERE name = 'MyPackageName'

Or this:

exec msdb..sp_get_dtspackage @name = N'PackageName', @id = 'PACKAGE_GUID', @versionid = 'VERSION_GUID'
--you can get PACKAGE_GUID from going to Package/Properties from DTS Designer
--you can get VERSION_GUID from Package/Properties from DTS Designer

The payload is in the packagedata field. However it is in binary format so there is not much manipulation that can be done with the field.

有效负载位于packedata字段中。然而,它是二进制格式,因此可以使用该字段进行很多操作。

This technically answers the question from the perspective of the physical location.

从技术上讲,这从物理位置的角度回答了这个问题。

#1