|
Execute the following script in Query Editor to create a sproc for DTSRUN execution :
CREATE PROC ImportFinanceData
AS
BEGIN
DECLARE @SQLCommand varchar(1000)
SET @SQLCommand = 'DTSRUN /S 140.242.136.106 /E /U "user" /P "password" /N
"DailyFinanceImport" '
EXEC master..xp_cmdshell @SQLCommand, NO_OUTPUT
END
GO |