在设计SSIS 的时候,debug的时候,发现:
[Connection manager "Sandbox.OLEDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot generate SSPI context".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "SQL Server Network Interfaces: 系统检测到危害安全的尝试。请确认您能与对您进行身份验证的服务器联系。
".
原因是:这里的Debug Options - Run64BitRunTime设置为true了,改为False,就可以通过。