Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bigey3
Starting Member
6 Posts |
 Posted - 2008-04-18 : 05:22:40
|
| Hi, I would like to run a DTS located on a server command line from a client, both machines are well understood in the same network. Syntax: C: \ Documents and Settings \ jtchamdja> dtsrun.exe / s \\ moovbill1 / u sa / p / e / n dbterm07 My problem is that I get a runtime error: DTSRun *: loading ... Error: -2147467259 (80004005); error provider: 17 (11) Chain of error: [DBNETLIB] [ConnectionOpen (Connect ()).] SQL server This does not exist or access is denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Background aid: 0 Please give me a real helping hand to understand the mistake and how to remedier. if you have other tips, I am hearing everything. Thanks A + |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-18 : 05:27:21
|
| [code]dtsrun.exe /S moovbill1 /U sa /E /N dbterm07 [/code]You can't use Trusted connection and user-supplied login credentials at a time. Also remove double backward slash characters before server name.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
bigey3
Starting Member
6 Posts |
Posted - 2008-04-18 : 06:21:58
|
| hi thanks for the help but i dont understand ;please can you explain this for me,you can also send an example forme.thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 16:51:59
|
| Server name doesn't need \\ in front, either use -e option or use -u and -p. |
|
|
|
|
|
|
Error executing a DTS command line in windows(cmd)