I have an SSIS package that imprts data from a flat file into a database table.
During the import a column is added to the source data with the timestamp of when the package is run...
this adds the timestamp to the LoadDate column of the table
I want the time component of the timestamp to be all zeros
so in this example the entries for LoadDate would be
I tried putting the following in the expression
but it is not accepted.
any help appreciated thanks.