import data into table that has a timestamp
Hello, I have a simple table: (zip code, city, country) and I need to import it into a table that is setup like (timestamp, zip code, city, country). I am using SSIS to do the import. How do I handle the timestamp? Do I add a column in SSIS? Or since the time really does not matter can I just add that column to my flat file? What would that data value look like if I did that? Right now in the existing table it looks like: 0x00000000000563E3
July 13th, 2012 2:30pm

Timestamp columns are auto filled, you cannot insert a value manually. So when you define your column mappings just leave that one unmappedChuck Pedretti | Magenic North Region | magenic.com
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 2:33pm

Hi, No need to explicilty takew care of timestamp column. Timestamp(rowversion) gets generated automatically everytime row inserted and updated. just do not map anything too it..- Chintak (My Blog)
July 13th, 2012 2:34pm

Hey it worked! I was just scared of messing something up. Thanks!
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 2:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics