Как запустить 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)