Hello all,
I'm playing with a new business adapter to import data into my database, but I get an error. It references a temp table that I use in my query, so I'm guessing that the Business Adapter Studio does not like that?
I can always import the data as multiple imports and then join, so not a big deal. But I thought I would ask... 😉
Thanks!
Matt
Jun 21, 2021 01:58 PM
Yep - I think you have worked it out. The Business Adapter Studio uses a SQL Server OLEDB provider interface to try to work out what columns of data are returned from your query, but the provider isn't smart enough to be able to work that out when you've used a temp table in the query.
Jun 21, 2021 11:33 PM
Yep - I think you have worked it out. The Business Adapter Studio uses a SQL Server OLEDB provider interface to try to work out what columns of data are returned from your query, but the provider isn't smart enough to be able to work that out when you've used a temp table in the query.
Jun 21, 2021 11:33 PM