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