DTS in SQL 7

Results 1 to 2 of 2

Thread: DTS in SQL 7

  1. #1
    Join Date
    Dec 1969

    Default DTS in SQL 7

    I need to insert one tables values into another.<BR>Table 1 does not have ID field. Table 2 has ID has identity field. When I try to insert via DTS it gives ID cannot be null. Why doens&#039;t it enter automatically? Help

  2. #2
    Join Date
    Dec 1969

    Default RE: DTS in SQL 7

    A simple way to fix this is go into you DB and click on the field - make sure the "Accept Null Value" is equal to yes.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts