Как запустить DTS из StoredProcedure |
Previous Top Next |
Code: |
use master exec xp_cmdshell "DTSRun /S servername /U username /P password /N packagename"
|
Автор Akim
©Drkb::02789
Взято из http://forum.sources.ru
1.
Code: |
--©Drkb v.3(2007): www.drkb.ru
Exec master..xp_cmdshell '"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe" /S'+@ServerName+' /U'+@SQLUserName+' /P'+@SQLPassword+' /N'+@DTSPackageName |
2.
Code: |
--©Drkb v.3(2007): www.drkb.ru
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' |
©Drkb::02790
Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)