I am working on sql server. i am using bcp utility,a utility similar to sql*loader in oracle. I will be uploading data into a table using a flat file, but the flat file will not have the date value for one of the date columns.
What i want is while the loading data i want the date column to have default of system date inserted into that column.
Please help me on this
thanks in advance.