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
Question
Question
Create identity token checkbox not visible when connected table in a custom schema.
asked on November 14
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.