add column on the result of the business adapter

[tallal85]

Hi,

With a sql query I connected my business adapter to a database to list the users.
and after that, I want to add a column in my result of the business adapter with the name of a license.

I test with "add column" but i have an error message.

Regards,

[JJacildo]

Hi, will you be able to post the error message you are getting?

[tallal85]

yes here is the error message

[ChrisG · Accepted solution]

First of all, "GO" is not a Transact-SQL statement, so you can't include that in your query text. ("GO" is a command used in interactive tools like SQL Server Management Studio to send batches of commands to SQL server.)

Secondly, you can only include a single "SELECT" statement in the adapter's query field to retrieve data to be imported. If you want to execute other direct SQL statements during the import process after to be imported data has been retrieved, you should add a custom object in your adapter

Thirdly,  "ADD COLUMN" is not a Transact-SQL statement either. I suspect you are meaning to use the "ALTER TABLE" statement. For example:

ALTER TABLE #ECMImport_YourImportName
ADD COLUMN licensename NVARCHAR(256)