Ah OK so you want the time component in the SQL table as well? I will have another go at this but you can probably do it using a derived...

Have you tried creating a derived column after the source and using SUBSTRING to extract the first 10 characters to a new column and mapping this to your date column....

Hi

If you setup a foreach loop container and then add a Data Flow to that.

Add the source file and then a Script component (Transformation Type) with 3 Outputs (see attachment)

The...