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 |
|
Christine Glew
Starting Member
7 Posts |
 Posted - 2002-06-20 : 11:47:54
|
| I am having a problem running a DTS package in SQL2000. If I execute the package manually from DTS it runs fine. If, however I schedule it, it fails with the message 'invalid switch'. If I copy the command created in the scheduled job and run it from the command line it also fails with the same message. This is the statement that has been created DTSRun /~Z0x95852DBF93F182276E100303E73F769555E33B6BEDD01F8F6AA5B02E0190A0A097AF787EF887A277468E6FBA2FB87FA89359FE7F19186E822A93228575C4691C0FAC098EE9B0571F381C46CF3B04C8F1637D444690D880CC268AE10E3018312DB4833CBB866F99AE48510268E5FAB11A51C27441EAD797D39A88CE6EC8ECEA90C7A77FE20D8E4FEBBDFC360ED0BBECB95958723533745F3B935C9C7C4793E12FF13DEB |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-20 : 16:08:23
|
| Can you post the exact error message your recieve? What happens if you construct your DTSRun call without the encryption (manually type it all out and manually set the parameters...)?<O> |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-20 : 17:39:19
|
| The easiest way to generate a DTSRUN command is via the dtsrunui interface - it will generate it for you, global variables et al.Not that its particularly trick yanyway. Check BOL for details of the syntax and set up the job manually - you'll find it easier in the long run HTHJasper Smith |
|
|
|
Christine Glew
Starting Member
7 Posts |
Posted - 2002-06-21 : 05:53:30
|
| I took your suggestion of generating the command via DTSRUNUI. When I used the generate feature, this is what it generated:DTSRun /S "PRO33\SQL2000" /U "sa" /N "Pull ILDBaudit data from PRO33" /R "." /G "{07CF814F-5CDC-11D6-BF0B-000347C73580}" /L "C:\MSSQL\dtserrors.txt" /W "0" when I ran this I got 'Invalid switch: /L "C:\MSSQL\dtserrors.txt" The parameter is incorrect'when I took out the /L switch I got 'Invalid switch: /W "0" The parameter is incorrect'When I took out the /W switch it ran fine.I noticed using DTSRUNUI there is an option for SQL server 7 format, I tried using this option and it generated the command that worked (i.e. without the /L and /W switches) but when I tried to schedule the job it did not keep the SQL server 7 format option and scheduled the failing statement. Obviously I have got a workaround now as I have found a statement that works, but it would be nice to know why the SQL2000 parameters do not work for me. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-21 : 08:21:09
|
| Does that directory exists? There is no logging in DTS on SQL7, so using SQL7 format will result in removing those flags. That makes sense. Maybe you somehow have SQL7's version of DTSRun on you machine? What happens at the command line when you type "DTSRun /?" .... do you see a /L switch?<O> |
|
|
|
Christine Glew
Starting Member
7 Posts |
Posted - 2002-06-21 : 12:16:25
|
| Thanks for your help, I have found that the problem just relates to one particular server which has both SQL Server V7 and an instance of SQL2000 on it. |
|
|
|
|
|
|
DTSRUN