General discussion

Locked

Importing to SQL7.0

By eaglejc_99 ·
The company that I work for has put me in charge of importing a list to our SQL database I know about DTS but the question that I have is this: I need to know how to get the list to pick up the last ID in the contacts table and then increment whileimporting.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Importing to SQL7.0

by ketanparekh In reply to Importing to SQL7.0

Probably you can use Append data option in transfer object

The information is not sufficient. are you using identity in any of the table? do you want to append the table or replace the table? Is source table taking care of ID number?.

Collapse -

Importing to SQL7.0

by eaglejc_99 In reply to Importing to SQL7.0

The question was auto-closed by TechRepublic

Collapse -

Importing to SQL7.0

by Crowmoor In reply to Importing to SQL7.0

You have to get me more details to help you.

Generally you could use SELECT LAST to get the last post and then run another query which selects the rows larger than that value.

Jesper

Collapse -

Importing to SQL7.0

by eaglejc_99 In reply to Importing to SQL7.0

The question was auto-closed by TechRepublic

Collapse -

Importing to SQL7.0

by eaglejc_99 In reply to Importing to SQL7.0

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums