Issue: Getting error while executing the batch job in SAP DS

[JayshilShah]

I hope you are doing great. We are stuck in a process of transferring the data from one server to another server using SAP DS.

We require your help in solving the issue. Here I am explaining the issue to you.

Error: ODBC call <SQLDriverConnect> for data source <X.Y.Z.A> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

We have created 2 repositories, the first one is for source and the second one as target.

We have views in the form of tables in the source repository which contains the data that we need to transfer.

We have already imported the tables to the SAP DS designer.

Now, we are trying to create a batch job which has the structure below.

We have created a dataflow as below.

We have done the column mappings in query editor.

But while executing the job, we are getting the error shown below.

We are able to connect with both the servers from the SAP Data Services, and the connectivity has been stable without any interruptions.

Despite both servers being connected successfully, the job fails with the same error that I shared in the above screenshot.

Can you please help us resolving this issue?

It is very critical for us, and we are unable to understand the root cause of this issue.

Please guide us how to resolve the issue and it will be a great help to us.

[JayshilShah]

I hope you are doing great. We are stuck in a process of transferring the data from one server to another server using SAP DS.

We require your help in solving the issue. Here I am explaining the issue to you.

Error: ODBC call <SQLDriverConnect> for data source <X.Y.Z.A> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

We have created 2 repositories, the first one is for source and the second one as target.

We have views in the form of tables in the source repository which contains the data that we need to transfer.

We have already imported the tables to the SAP DS designer.

Now, we are trying to create a batch job which has the structure below.

We have created a dataflow as below.

We have done the column mappings in query editor.

But while executing the job, we are getting the error shown below.

We are able to connect with both the servers from the SAP Data Services, and the connectivity has been stable without any interruptions.

Despite both servers being connected successfully, the job fails with the same error that I shared in the above screenshot.

Can you please help us resolving this issue?

It is very critical for us, and we are unable to understand the root cause of this issue.

Please guide us how to resolve the issue and it will be a great help to us.