ETL Help: Loading SAS Datasets to MS SQL Server

Two things. There is a warning about a timeout of 3 seconds which might not be enough.

2020-03-20 11:10:09,303 : WARN : main : : Node : DB Insert : 0:381 : java.sql.SQLException: I/O Error: Connection reset by peer: socket write error
2020-03-20 11:10:21,742 : WARN : main : : DBDataPortObjectSpec : DB Insert : 0:381 : Node configuration was aborted after 3 seconds. To change the timeout parameter ‘Retrieve in configure timeout’ go to the ‘Advanced’ tab of the database connector node.

And a strange warning about a file NULL that could not be read by the SAS reader which might be connected to the NULL problem.

2020-03-19 20:22:56,563 : WARN : main : : Node : SAS7BDAT Reader : 0:369 : C:\Program Files\KNIME\null (The system cannot find the file specified)

You might want to check that. Maybe use a path with KNIME protocol.

Maybe you could provide us with a simple SAS file with unsuspicious data from your system so we might have a try.

3 Likes