dtsrun /S "Server" /E /N "DTS_Package" /A LocalConnServer:8="Server" /A LocalConnDBName:8="DB" /A LocalConnLogin:8="SQL_login" /A LocalConnPassword:8="pass"

USE [DB]
GO
/****** Object:  StoredProcedure [dbo].[sys_DTSRun]    Script Date: 12/04/2019 06:54:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[sys_DTSRun]
    @DTSName      varchar(128),
    @DTSParamStr varchar(500),
    @Result             int                  OUTPUT    --   0 - success, 1 - failure
AS
  
DECLARE @LocalServer varchar(128), @LocalDBName varchar(128), @LocalLogin varchar(128), @LocalPassword varchar(128)
DECLARE @ParamStr varchar(3200)
DECLARE @DTSName_ varchar(128), @Command varchar(3200), @Param varchar(3200)
  
  
SELECT @LocalServer=Server, @LocalDBName=DBName, @LocalLogin=Login, @LocalPassword=Password FROM sys_Connections WHERE DBID='DBLOC'
SET @DTSName_=LTRIM(RTRIM(@DTSName))
SET @ParamStr='LocalConnServer:String="'+@LocalServer+'";LocalConnDBName:String="'+@LocalDBName+'";LocalConnLogin:String="'+@LocalLogin+'";LocalConnPassword:String="'+@LocalPassword+'"'
IF @DTSParamStr IS NOT NULL AND LTRIM(RTRIM(@DTSParamStr))<>'' BEGIN
    SET @ParamStr=@ParamStr+';'+@DTSParamStr
END
SET @Param=dbo.dtsrun_GenerateParameters(@ParamStr)
SET @Command='dtsrun /S "'+@LocalServer+'" /E /N "'+@DTSName_+'"'+@Param
  
EXEC @Result = master.dbo.xp_cmdshell @Command

DTSRun:  Loading...

DTSRun:  Executing...

DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_2

DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_2

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_4

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_4

DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2

DTSRun OnError:  DTSStep_DTSExecuteSQLTask_2, Error = -2147220421 (8004043B)

   Error string:  The task reported failure on execution.

   Error source:  Microsoft Data Transformation Services (DTS) Package

   Help file:  sqldts80.hlp

   Help context:  1100



Error Detail Records:



Error:  -2147220421 (8004043B); Provider Error:  0 (0)

   Error string:  The task reported failure on execution.

   Error source:  Microsoft Data Transformation Services (DTS) Package

   Help file:  sqldts80.hlp

   Help context:  1100





Error:  -2147217900 (80040E14); Provider Error:  18456 (4818)

   Error string:  Login failed for user 'sa'.

   Error source:  Microsoft OLE DB Provider for SQL Server

   Help file:  

   Help context:  0



DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_2

DTSRun:  Package execution complete.

LoadLibraryFromPath: FQ Dll C:\Windows\system\oci.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\oci.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\oracle\product\11.2.0\client_32\bin\oci.dll found 
LoadLibraryFromPath: FQ Dll C:\Windows\system\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\oracle\product\11.2.0\client_32\bin\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\oracle\product\11.2.0\client_64\bin\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll G:\oracle\product\agent11g\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files\HP\NCU\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\system32\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\System32\Wbem\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\System32\WindowsPowerShell\v1.0\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\idmu\common\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files\Microsoft SQL Server\100\DTS\Binn\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files (x86)\System Center Operations Manager 2007\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files\System Center Operations Manager 2007\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Program Files\ESET\ESET Security\SQLLib80.dll is not found, error: 0x7e 
LoadLibraryFromPath: FQ Dll C:\Windows\System32\WindowsPowerShell\v1.0\SQLLib80.dll is not found, error: 0x7e