create proc sp_DTSWrapper ( @msg varchar (255) , @str varchar (255) = null output )
as
set nocount on
declare @pkg int ,
@rc int ,
@hr int ,
@source varchar (255)

exec @rc = sp_OACreate 'DTS.Package' , @pkg output

exec @rc = sp_OAMethod @pkg
, 'LoadFromSQLServer'
, null ,
, @ServerName = "(local)"
--, @ServerUserName = "sa"
--, @ServerPassword = "pwd"
--, @Flags = 0 -- SQL Server authentication
, @Flags = 256 -- NT authentication
, @PackageName = "MyDTSPAckage"

exec @rc = sp_OASetProperty @pkg ,
'GlobalVariables ("MyGlobalVar1").Value' , @msg

exec sp_OAMethod @pkg , 'Execute'

exec @rc = sp_OAGetProperty @pkg ,
'GlobalVariables ("MyGlobalVar2").Value' , @str out

exec sp_OADestroy @pkg

--Note that if you are not using SQL Sever authtication, you'll need to un-comment the
--three lines in the call to LoadFromDQLServer and comment out the
--Line for @flags = 256

go