:unsure:Great article but I have a specific question not covered within. I have written a DTS package to be scheduled to run nightly to synchronize two databases. I have written a query which runs fine bar 1 thing. I have included a constant field ie 'S' as [Record Type]in the SELECT clause, to flag the data from the DTS package. When I run the query in Query analyzer or in the DTS preview the constant field shows up fine but when I check the upload table that field is missing. Can anyone help. What difference does the constant value make. Thank you community in anticipation. BigAl