How do i change DTS options in sql server 2000 through SQL Query Analyzer? Such options are source, destination, transformation columns, etc..
如何通过SQL查询分析器更改sql server 2000中的DTS选项?这些选项包括源,目标,转换列等。
1 个解决方案
#1
You can't edit a DTS package through Query Analyzer; completely different set of tools. You do have a couple of options, however:
您无法通过查询分析器编辑DTS包;完全不同的工具集。但是,您有两个选择:
The closest you could come to this (and my DTS skills are very rusty) is to design your DTS package to look at a Parameters table in a SQL database, and edit those parameters via Query Analyzer.
你最接近这个(我的DTS技能非常生疏)是设计你的DTS包来查看SQL数据库中的Parameters表,并通过查询分析器编辑这些参数。
Your second option (assuming you have xp_cmdshell enabled on your server) would be to use external variables in DTS, and use DTSRUN via xp_cmdshell to pass in those external variables. This is a bit of a kludge, but if you're trying to call a DTS package from a stored procedure with different parameters, it may be more robust than the first method (i.e., allows multiple instances of the proc to run without interference).
您的第二个选项(假设您的服务器上启用了xp_cmdshell)将在DTS中使用外部变量,并通过xp_cmdshell使用DTSRUN传入这些外部变量。这有点像kludge,但是如果你试图从具有不同参数的存储过程调用DTS包,它可能比第一种方法更健壮(即,允许proc的多个实例在没有干扰的情况下运行) 。
HTH, Stu
#1
You can't edit a DTS package through Query Analyzer; completely different set of tools. You do have a couple of options, however:
您无法通过查询分析器编辑DTS包;完全不同的工具集。但是,您有两个选择:
The closest you could come to this (and my DTS skills are very rusty) is to design your DTS package to look at a Parameters table in a SQL database, and edit those parameters via Query Analyzer.
你最接近这个(我的DTS技能非常生疏)是设计你的DTS包来查看SQL数据库中的Parameters表,并通过查询分析器编辑这些参数。
Your second option (assuming you have xp_cmdshell enabled on your server) would be to use external variables in DTS, and use DTSRUN via xp_cmdshell to pass in those external variables. This is a bit of a kludge, but if you're trying to call a DTS package from a stored procedure with different parameters, it may be more robust than the first method (i.e., allows multiple instances of the proc to run without interference).
您的第二个选项(假设您的服务器上启用了xp_cmdshell)将在DTS中使用外部变量,并通过xp_cmdshell使用DTSRUN传入这些外部变量。这有点像kludge,但是如果你试图从具有不同参数的存储过程调用DTS包,它可能比第一种方法更健壮(即,允许proc的多个实例在没有干扰的情况下运行) 。
HTH, Stu