我有一个SSIS工作，我需要通过SSH激活。 SSH服务是BitVise。 我能够使用我的Unix主机上生成的密钥进行连接。
我在我的Unix主机上运行以下脚本：
#!/usr/bin/env bash # expects host configuration in ~/.ssh/config # Host ssis-test # HostName SSISTEST # User WINDOWSUSER # Port 22 # IdentityFile /home/foo/.ssh/ssis_dsa # PasswordAuthentication no # ssh ssis-test "D:\\Airflow\\run-ssis.bat" 。 。 。 它只是在Windows主机上调用一个脚本。
然后我看到以下错误：
Microsoft (R) SQL Server Execute Package Utility Version 12.0.4100.1 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:39:31 PM Progress: 2017-09-15 13:39:31.70 Source: Data Flow Task Validating: 0% complete End Progress Progress: 2017-09-15 13:39:31.70 Source: Data Flow Task Validating: 50% complete End Progress Error: 2017-09-15 13:39:31.77 Code: 0xC0202009 Source: Extract VR CSV file Connection manager "WINDOWS-HOST\MY_CLIENT_RPT" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.". End Error Error: 2017-09-15 13:39:31.77 Code: 0xC020801C Source: Data Flow Task OLE DB Destination [67] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "WINDOWS-HOST\MY_CLIENT_RPT" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2017-09-15 13:39:31.77 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: OLE DB Destination failed validation and returned error code 0xC020801C. End Error
当我通过winrmlogin到我的Windows主机时，从命令提示符调用它的脚本工作正常。
看来，当我通过SSHlogin，OLE使用什么机制来获得我的域名\用户名没有被正确地搔痒。 在运行我的SSIS批处理之前，如何让OLE知道我是谁？