January 11, 2007 at 10:01 am
I have a standard file that I need to import to an existing table structure, basic DTS, no transforming of the data or anything like that. Currently this is done by truncating the old table and then filling it up with the most recent data, this has worked without any issues. Now there is a need to build an archive table and then put in a field that will define the date that the file is for (this is an eligibility file, so this will typically be a week ending date).
This shoud be done easily enough, we have a part time DBA who could knock this out for us, but I am trying to avoid bothering him with something that I feel I should be able to do myself.
Thanks,
Richard
January 11, 2007 at 1:07 pm
Prior to truncating the table why not just export the data to the archived table with an additional date column for your archived date? like.... Insert into Archive Select column1,column2,getdate() from tableA
CY
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply