ODBC error after upgrade to ETL 6.3.7.32 for reader on 4 of 100's of transformat

HI:
after upgrading to ETL enterprise 6.3.7.32 we are experiencing some ODBC errors on 4 of our roughly 100+ transformation readers using the same .txt file reader

the error we are getting in the log when run under a schedule is : "Not able to read the data: SQLConnect Failed: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" however when executed manually the error does not appear.

I was thinking it was a permission issue however that does not explain why it works for most transformations using it however these 4 are not. I have tried re defining the reader object but that did not help.

Most likely you need to update SQL Server ODBC drivers.
Please follow those instructions
www.etl-tools.com/wiki/knowledgebase/tip...server-odbc-drivers/ .

Keep us posted on your progress

upgrading to the either SQL odbc connector 13 nor 17 solved the issue.
I have also re created the writer object in the transformation to no effect either.
I still get the following error:

Information 12/16/2021 9:37:07 AM Starting Transformation...
Information 12/16/2021 9:37:07 AM Map Name: 1SB-Trans
Information 12/16/2021 9:37:07 AM Author:
Information 12/16/2021 9:37:07 AM Version:
Information 12/16/2021 9:37:07 AM Description:
Information 12/16/2021 9:37:07 AM Is In List:{In List: } In List: - Loading List of Values
Information 12/16/2021 9:37:07 AM Connection Type is: Unknown
Information 12/16/2021 9:37:07 AM Reading all specified Table(s)
Information 12/16/2021 9:37:07 AM Source Table:
Error 12/16/2021 9:37:07 AM SQLConnect Failed: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Warning 12/16/2021 9:37:07 AM Unable to determine number of records in the Data Source:
Error 12/16/2021 9:37:07 AM SQLConnect Failed: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


thanks

mike

Please post a screenshot of "Is In List:{In List: }" object

I am attaching images of the validator with images of the in list object.

also to note. for this one, I was able to make it work properly by re creating the entire transformaion from scratch and it works. but this seems like a lot of work to do all the ones failing.

thanks

mike

Here is the error message you had

Information 12/16/2021 9:37:07 AM Is In List:{In List: } In List: - Loading List of Values
Information 12/16/2021 9:37:07 AM Connection Type is: Unknown

If the connection is missing or deleted the lookup will stop working



There is no need to rebuild everything from scratch