Rich : legacy rovctd der file loading This page last changed on Oct 05, 2009 by rich. First: truncate table ctdder Then, working in small batches within a single year Open the dts job ROVCtdDerLoader and set the connection1 property to point to the der file you want to load and then run it Repeat as needed... Then fix the target table below in two places: the year, and the platform id (989 is tibr, 988 is vnta) INSERT INTO RovctdBinData_1997 (DatetimeGMT, DeviceID, EpochSecs, LoadID_FK, bin, p, t, c, s, o2, light, oc, ot, trans, rlat, rlon, ptsFlag, o2Flag, lightFlag, latlonFlag, ProcessingID_FK) SELECT [dbo].EpochSecondsToDTG(usec) as DatetimeGMT, 989, usec, -1997, usec, pres, [temp], cond, dbo.Salinity(cond,temp,pres), oxyg, light, o2curr, o2temp, transvolt, lat, lon, 2, 2, 2, 2, 0 FROM ctdder go ---truncate table ctdder ---go

Document generated by Confluence on Feb 04, 2026 08:50