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 |
|
rweasel6
Starting Member
6 Posts |
 Posted - 2007-04-30 : 16:49:15
|
| The answer was easily found here. Just took some time to find through internet searches.http://www.sqldts.com/301.aspxyou can let the DTSrunui generate the command line for you. I think I was missing the GUID piece.Im trying to run a DTS Package Stored in the DTS Folder as a Local Package on the sql server but I cant get the syntax right. Im running SQL on the local machine.Here is the command line Im trying to run. I keep getting a "you must specify a package name error.dtsrun /S <server name>/U test/P test/N Bulk_Ship_LoadHow do I specify the server name as the local machine? and am I just way off ? I have read through the internet and the books and I guess I just dont see it.I also have a saved query that I need to run after the import is complete. do I just specify to execute a sql task on completion? |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-05-01 : 10:19:58
|
| /s <computer name> should work. Did you also try /s (local)? |
 |
|
|
|
|
|
dtsrun syntax problem?