Всем Ку!
В первый раз погрузился в такую страшную вещь как DTS пакеты.
Прошу Вашей любой помощи. И так коротко о деле:
1. Есть джоб с SQLExec
1.
dtsrun /S "Server" /E /N "DTS_Package" /A LocalConnServer:8="Server" /A LocalConnDBName:8="DB" /A LocalConnLogin:8="SQL_login" /A LocalConnPassword:8="pass"
2. Также конечно есть DTS_Package, но открыть я его не смог похоже нужна Visual Studio
3. Есть хранимка sys_DTSRun
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.
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
4. Проблема в том что не отрабатывает джоб, при чем при дебагинде ошибки, вижу что ошибка пароля выходит на соседнем инстансе и под юзером sa, хотя я не вижу где используется sa. Пароли везде выравнил, но проблема осталась. Подскажите любую информацию, т.к. зашел в тупик....
5. По самому джобу следующая ошибка:
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.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
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
