A quick and easy way is to use a UDL file (universal data link) - create a new text file with .UDL extension, then double click on it and it...

In my DTS I'm using the following, which seems to work well:

ALTER TABLE <tablename> NOCHECK CONSTRAINT <fk name>

Run delete/import script

ALTER TABLE <tablename> CHECK CONSTRAINT <fk name>

You could write your own stored proc using system stored proc sp_columns to return list of cols and datatypes for the table, then build up script string from there.

This functionality is built into Enterprise Manager - right click on the table you want, select ALL TASKS then GENERATE SQL SCRIPT. Go to the OPTIONS tab for settings relating...