Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS error when importing to table w/timestamp column

Status
Not open for further replies.
wltenney

wltenney

Programmer
Mar 16, 2001
9
US
I am trying to import data from an Excel spreadsheet to a table using DTS. The table has a timestamp column which is giving me fits. I keep getting an error: "Integrity violation; attempt to insert NULL data or data which violates constraints." I have tried including the timestamp column in the transformation as well as leaving it out, but the results are the same.
Would appreciate any help.

Thanks
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
356
BobSuruncle
BobSuruncle
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
318
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
470
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
286
Andrzejek
Andrzejek
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
373
Volvere
V

Part and Inventory Search

Sponsor

Back
Top