use master
exec xp_cmdshell "DTSRun /S servername /U username /P password /N packagename"

--©Drkb v.3(2007): <a href="http://www.drkb.ru

Exec" title="www.drkb.ru

Exec">www.drkb.ru

Exec</a> master..xp_cmdshell '"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe" /S'+@ServerName+' /U'+@SQLUserName+' /P'+@SQLPassword+' /N'+@DTSPackageName

--©Drkb v.3(2007): <a href="http://www.drkb.ru

" title="www.drkb.ru

">www.drkb.ru

</a> Declare @retval int,

  @package int,

  @ServerName char(20),

  @LoadString varchar(8000)



 Set @ServerName=CONVERT(char(20), SERVERPROPERTY('servername'))

 Set @LoadString='LoadFromSQLServer("'+@ServerName+'", "'+@ServerLogin+'", "'+@ServerPassword+'", 256, , , ,"'+@DTSPackageName+'")'

 EXEC @retval = sp_OACreate 'DTS.Package', @package OUTPUT

 EXEC @retval = sp_OAMethod @package,@LoadString,NULL

 EXEC @retval = sp_OAMethod @package, 'Execute'