You are viewing limited content. For full access, please sign in.

Question

Question

Create identity token checkbox not visible when connected table in a custom schema.

asked on November 14

Hi,

We are having an issue that we cannot return an identity token when inserting data into a table that belongs to a custom schema. The checkbox isn't available.

We have observed this across multiple schemas.
We have ensured that the user making the connection in Workflow has every right but take ownership.
We are working with a base table, not a view or other types of objects.

Is this known bug? I haven't found clear documentation that it is. We are on the latest build of 11

Zane

0 0

Replies

replied on November 16 Show version history

Hi Zane,

 

Please recheck the table has an identity column. You may run the following query to get the tables that have identity columns. If the table does not exist in the result, the Create identity token checkbox will not be visible which is expected.

SELECT 
  [schema] = s.name,
  [table] = t.name
FROM sys.schemas AS s
INNER JOIN sys.tables AS t
  ON s.[schema_id] = t.[schema_id]
WHERE EXISTS 
(
  SELECT 1 FROM sys.identity_columns
    WHERE [object_id] = t.[object_id]
);

 

Or you may use custom query activity to insert data with

Select SCOPE_IDENTITY() as XXX;

 to get the new identity token if you are using a SQL Server. XXX is the token name that you can renamed.

 

Thanks,

Zhujie

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.