Sorry for the delay - have been away this weekend. I've generated some sample data and created an example table as below. The data is a decent representation of the quality of the data in the files I have. Please remember that this is tab delimited txt files.

MEMIDSAMPLE1SAMPLE2SAMPLE3SAMPLE4

101/09/072007090101092007

201/09/200702092007

317/10/1999

417/10/199920300612

512/01/2020

615/08/203012/01/2019970508

715/08/199715/08/3003092007

828/03/200215/08/9704092007

905092007

1028/03/200206092007

CREATE TABLE [dbo].[ExampleDates](

[MEMID] [int] NOT NULL,

[SAMPLE1] [datetime] NULL,

[SAMPLE2] [datetime] NULL,

[SAMPLE3] [varchar](10) NULL,

[SAMPLE4] [varchar] (10)NULL

) ON [PRIMARY]

In terms of screen shots please see attached word doc.

The odd thing is that I can't produce this data on the system I have to work on as it is locked down with no internet access. So I produced this on my own machine and the data goes in correctly. So this leads me to think that it isn't so much the data as the set up of the Server itself.

Would be grateful for any suggestions.

Many thanks