Source: Incidentes Connection manager "Oracle" 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 'gai_hseq[/b]'.". An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Invalid connection string attribute".
From the error message, the login gai_hseq doesn't exist in SQL Server or the password is wrong.
The connection manager is named 'Oracle', but it's connecting to SQL server (Microsoft OLE DB Provider for SQL Server). Are you sure the connection string is correct?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability