SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Reading .XML files into SAS Dataflux DMS v2.5

Reply
Occasional Contributor
Posts: 19

Reading .XML files into SAS Dataflux DMS v2.5

Hi,

I am trying to set up an ODBC data link to read a .XML file but am getting the following message that the FXXML27S.DLL could not be found - along with a system error 126 (see below)

Can anybody advise if this is a standard add-in for SAS (and we should have it) or is licence dependent

thanks

Nigel

xml error.JPG

SAS Employee
Posts: 75

Re: Reading .XML files into SAS Dataflux DMS v2.5

Hi Nigel, the DM Studio user guide has a usage note that might help:

Data Connection Usage Notes

It says:

ODBC XML Connections

How can I read an XML file in a data job?

Due to the limitations of the ODBC 32-bit XML driver, we recommend that you use the XML Input node to read an XML file in a data job.

Occasional Contributor
Posts: 19

Re: Reading .XML files into SAS Dataflux DMS v2.5

Hi,

Thanks for the info - I have followed the link and it seems that I need to download an .XML mapper

Regards

Nige

Occasional Contributor
Posts: 19

Re: Reading .XML files into SAS Dataflux DMS v2.5

Could this be the answer - non-compatibility? https://support.microsoft.com/en-us/kb/260558

No luck in getting this to work - back to plan B (save it as a delimited .txt file) which seems to work

Ask a Question
Discussion stats
  • 3 replies
  • 467 views
  • 3 likes
  • 2 in conversation