Hi Russel - Just wanted to report back that your suggestions worked! After much travail, I got the DTS package to work as you described. Thanks again for your input.

Okies, I think I got a solution:

update Table1

set newDateTimeField = substring(ldaptimefield,1,4)+'-'+

substring(ldaptimefield,5,2)+'-'+

substring(ldaptimefield,7,2)+' '+

substring(ldaptimefield,9,2)+':'+

substring(ldaptimefield,11,2)+':'+

substring(ldaptimefield,13,2)

The data in the ldaptimefield is text and looks like this 20060816211120Z, etc. The newDateTimeField has datetime field format. So,...

Well he did preface the article by saying that people might have other software to do this sort of thing easily. For those situations where DBA's don't have that, this technique is a...