I have a SSIS package for getting data from a webservice and insert to the SQL Server(using OLEDB connection with sql user).
but I would like to add the agent job on SQL Ad-hoc server by using a filesystem package source.
So, the job agent will execute on SQL Ad-Hoc Server but inside a package will getting data from a webservice and import to another server.
Is it impossible to do that? I try this solution but found error about "Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E4D Description: "Login failed for user "
and
Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state."
but I can set a CREDENTIAL across a server ><
Could someone please help me with this problem
Thank you
User contributions licensed under CC BY-SA 3.0