question

Pabitra avatar image
Pabitra asked

Cannot insert the value NULL into column 'ID', table 'Azure'; column does not allow nulls. INSERT fails.

I have peculiar situation where the SSIS package called from sql agent job is showing the below error. Cannot insert the value NULL into column 'ID', table 'Azure'; column does not allow nulls. INSERT fails. But i do not find any null value for the column ID. And when i try to run the package directly, it loads data to destination without any issue. Could anyone help me understand this issue?
null
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.