-
DTSRun Parameters
Hi
Having looked at the MS site I am confused by the syntax I should be using for DTSRun in SQL Server 2000.
The MS site says the syntax is ...
dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password
Given a SQL Servername of 'machinename\Tstradli', SQL Server User name of 'SA', Password of 'Fred', and a Package Name of 'DoPost' and no package password that I can discern ...
I am using the string
"DTSRun /Smachinename\Tstradli /USA /PFred /NDoPost"
and I am getting the error "The filename, directory name, or volume label syntax is incorrect." so obviously SQL Server cannot see my DTS package ...
Does any body know what I am doing wrong here? Do I need to specify the owner of the package at any point?
Thanks
T
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|