Allow for a column list to be specified when using the Write Data In-DB tool

[riosjosh]

There is a known error when using the Write Data In-DB Tool. When writing to a table in MS SQL database that has a "identity" column you get the following error: Error: Write Data In-DB (X): Error running PreSQL on "NoTable": [DB Connection]An explicit value for the identity column in table [table_name] can only be specified when a column list is used and IDENTITY_INSERT is ON.

Essential this error happens when the table you are trying to write to has a column with the following configuration or similar: IDENTITY(1, 1) NOT NULL 

I am suggesting that the Write Data In-DB Tool should be configurable insert only to specified columns as identified by the user. Similar to the functionality of this SQL statement:

INSERT INTO [table_name]
    (column1, column2, column 3, etc...)
    VALUES (new_value1, new_value2, new_value3, etc...)

This would 1) solve the above issue (for which there is no viable workaround), and 2) allow users more flexibility in how they write their data.

The following community posts are related:

• MS SQL Identity Column using In-Database Tools
• InDB Write to MSSQL table with Identity column, error
• MS SQL Server: Identity Field, Identity Insert and ODBC vs. OLEDB
  
   

[folopes]

Same problem here. 😞