1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
BEGIN
DECLARE @description varchar(255)
-- create an instance of the DTS package
exec @rc = sp_OACreate 'DTS.Package', @package output
-- load the package
exec @rc = sp_OAMethod @package,
'LoadFromSQLServer',
null,
@PackageName="RMSLoadImportFile",
@servername= @srv,
@ServerUserName=@DBusr,
@Flags=0
IF @rc <> 0
BEGIN
EXEC sp_OAGetErrorInfo @package
RETURN
END
-- Set global parameter values
exec @rc = sp_OASetProperty @package, 'GlobalVariables ("file_name").Value', @file_name
exec @rc = sp_OASetProperty @package, 'GlobalVariables ("run_id").Value', @run_id
-- execute package
exec sp_OAMethod @package, 'Execute'
IF @rc <> 0
BEGIN
EXEC sp_OAGetErrorInfo @package, @description OUT
insert into import_errors
(import_id, import_str)
values
(@run_id, 'Error executing DTS package LoadImportFile; Error description: ' + @description)
RETURN
END
-- destroy the instance
exec sp_OADestroy @package
END |
Partager