|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
April 23rd, 2003, 10:25 AM
|
|||
|
|||
Remote DTS
I have a DTS Package that I need to run on a remote SQL 2000 server. The errors I am getting refer to the connections made inside the DTS. It's like the package is looking for the DSN on my machine instead of on the remote SQL server where it is setup.
The DTS runs fine when ran from the local machine, but when I run it from a remote machine it gives me this error: Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified How can I tell the DTS to run on the remote server? Thanks, Bruce
|
|
#2
August 6th, 2003, 11:55 AM
|
|||
|
|||
|
Had this before. what you can do is open the query analyzer, connect to the remote server and
Code:
EXECUTE master.dbo.xp_cmdshell 'dtsrun /S (local) /U {uid} /P {password} /N {name dts package}'
With this you can see whether the package executes well or not. If you wish to schedule this package on the remote server you need to modify the DTSrun on each step from the schedule as well. Modify the dts to read the same: dtsrun /S (local) /U etc.... via the Tab Steps and the button Edit This worked for me before Hope this helps
__________________
- Rogier Doekes
|
|
#3
April 22nd, 2004, 06:17 AM
|
|||
|
|||
|
dts
Hi,
I would like to run a dts which is on the sql server 2000 The dts has a parameter which is strPath Currently each time I change the strPath manually in the parameters for each run. It is easier to use something like EXECUTE master.dbo.xp_cmdshell 'dtsrun /S (local) /U {uid} /P {password} /N {name dts package}' But the question is: How do I pass the parameter. Thanks
|
|
#4
July 26th, 2006, 07:57 AM
|
|||
|
|||
DTS parameters
Usage: dtsrun /option [value] [/option [value]] ...
Options ('/?' shows this screen; '-' May be substituted for '/'): Package retrieval: /~S Server Name /~U User Name /~P Password /E <Use trusted connection instead of /U /P> /~N Package Name /~M Package Password /~G Package Guid String /~V Package Version Guid String /~F Structured Storage UNC filename (overwritten if /S also specified) /~R Repository Database Name <uses default if blank; loads package from repo sitory database> Package operation (overrides stored Package settings): /~A Global Variable Name:typeid=Value <may quote entire string (including na me:typeid)> /~L Log file name /~W Write Completion Status to Windows Event Log <True or False> DTSRun action (default is to execute Package): /!X <Do not execute; retrieves Package to /F filename> /!D <Do not execute; drop package from SQL Server (cannot drop from Storage File)> /!Y <Do not execute; output encrypted command line> /!C <Copies command line to Windows clipboard (may be used with /!Y and /!X) > Notes: ~ is optional; if present, the parameter is hex text of encrypted value (0x3 13233...) Whitespace between command switch and value is optional Embedded whitespace in values must be embedded in double-quotes If an option is specified multiple times, the last one wins (except multiple /A) Hope that help
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Remote DTS |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
