Can run SSIS package on Ad-Hoc Server to insert result to another server?

0

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

sql-server
ssis
sql-agent-job
sql-agent
asked on Stack Overflow Jul 9, 2018 by user7333846

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0