Many times I have had to ask what portion of this date range was non-work time.

This does indeed vary by geography so we have added gmt start and end for...

I think it does not work with bulk transfer which i have to use for this volume of data

Oracle is the standard here so not sure i can get an...

Thanks Pete -

I finally got this data in by playing with the batch size and allowing 10 errors.

(identity was not mapped)

I am very interested in you comment on the exception file -...

Just wanted to add that the set identity insert is  not checked (tried it both ways already)

The columns are set as text and the registry is correct -

I am able to import the text and numbers - I am not getting any nulls.

with these settings...

Can you explain a little more about not needing indexes on date columns?

The majority of my searches use a date parameter and look at small portions of the data based...

Yes, the looping is the activex that continues the process untill all the files in the directory are processed

The Fail Flag on the logging tab was indeed the issue.  I...

There is no style for what i need -

Are you saying that adjsuting the length of the varchar will effectively drop seconds or hours for the purposes of the...