AnsweredAssumed Answered

Source Fields missing when using Calculated SQL text with Import Records

Question asked by lkingsella on Mar 19, 2017
Latest reply on Mar 19, 2017 by PowerSlave

When using the Import Records script step with an ODBC data source and calculated SQL text, no Source Fields are listed in the Import Field Mapping dialog. The target fields are listed, and the data does import, but I have to refer to my query to know the field order. If I use the SQL Text option, the Import Fields are shown, but I have date fields that change, so I have to use Calculated SQL text for my query. Am I doing something wrong? Thank you!