how to make Job launch DTS package?

[someITguy]

When trying :
EXEC xp_cmdshell 'dtsrun /S ServerName /N PackageName'

OR
ActiveX VBScipt solution:

Dim dtsp
Set dtsp = CreateObject("DTS.Package&quot
dtsp.LoadFromSQLServer "ServerName", _
"ServerUID", _
"Serverpassword", DTSSQLStgFlag_Default, _
"","","", "PackageName"
dtsp.Execute
dtsp.UnInitialize
Set dtsp = Nothing

I get following error msg :
"Error 22022: SQLServerAgent Error: Request to run job JOBNAME (from User USERID) refused because the job is already running from a request by User USERID" .

What do I have to do to start DTS package on the same server where job is? VBScript code works if I run it from outside of SQL2000.

 

[wilk]

check how the sqlserver agent, and mssqlserver is set up, what user is it loging on as, if it is local system then this can be a reason for it not working.

 

[osjohnm]

Hi

Go into Enterprise Manager, Data Transformation Services, Local Packages.
Find your DTS package, right click, Schedule Package and then select your options and then that will create ajob that executes the package at the time(or times) you set it for execution.

John