Post reply

dts import fails when using script - identity issue

  • May 5, 2005 at 2:39 am

    #185877

    When attempting to do some extra transforms in a transformation script, i have started getting 'cannot insert null value...' errors because i am not passing any data to the id field which is an identity column.

    The column is not selected in the Destination Columns and there is no 'Enable Identity Insert' checkbox in the Transform data task dialog.

    How do I get dts to ignore the id field?

  • May 5, 2005 at 2:46 am

    #557006

    solved. there was an enable identity insert checkbox in the 'options' tab that i hadn't recognised

  • May 5, 2005 at 10:28 am

    #557152

    thanks for the update.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply