Hello - Need some guidance on how best to get one of my data sources into a SQL Server table.
A bulk Insert is nice and easy, but here is where things get complicated.
I need to store a field that is calculated off one of the fields in the source data, but i am not able to store the field the calculation is based off of (not even in a temp table if i can get around it).
Is there a way to do a bulk insert and specify the fields I want, and do the desired calculation before anything is stored in a table? For example, lets say i wanted to store Years of Service (which is calculated off of a snapshot date and a field called Service Date, but I do not want to store the Service date).
Maybe a bulk insert is not the way to go?