dtsRun syntax

[SteveWilson]

Following on from previous thread - (but now different topic) Thanks for reply from JamesLean

I am having trouble trying to run the following dtsRun comand at the dos prompt

dtsRun S SERVER01444 /U MyUserName /P MyPassword /N DBName.dbo.dtsTest

I am receiving a message that A package name must be supplied? Can anyone help??

Tahnks

 

[JamesLean]

Firstly, I'm sure it's a typo but you're missing a / before the S switch.

Secondly, you don't need to qualify the name of your DTS package - they are stored in a table within the msdb database. Just specify the package name you saved it as. If the package name has spaces then surround it with double quotes:

/N"test dts package"

--James

 

[Bygbobbo]

I dont think you need the spaces after each switch either.

dtsRun /SSERVER01444 /UMyUserName /PMyPassword /N"dts package" /Aglobalvar_name:8="globalvar value"


Make sure you have persmissions on the Box to run command lines

hope that helps
--bygs