I have an SSIS job that I need to activate via ssh. SSH service is BitVise. I am able to connect using keys generated on my unix host.
I run the following script on my unix host:
#!/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"
. . . which simply calls a script on the windows host.
I then see the following error:
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
The script works fine when I call it from a command prompt when logged into my windows host via winrm.
It appears that when I log in via ssh, whatever mechanism OLE uses to get my domain\username is not being properly tickled. How do I let OLE know who I am before running my SSIS batch?
User contributions licensed under CC BY-SA 3.0