Sorry for the confusion, I guess the best way to explain it is if you go to the database properties and look at filegroups there are 3 primary files and if...

Thanx for the post Bond007 it does work a treat!

You were right on target sushila! OLEDB32.dll was still at version 2.7.  Upgraded to 2.8 changed registry and voila!  Thanks again for your help. 

Hi Michael and David,  the job finally works the way it should.  Thanks a lot !!! You guys are great. 

Hi Michael,  thanks for your reply, the column is stored as a decimal, but one of our developers came up with a solution. 

select * from tablename

where audittimestamp <

(

 ( cast...

A million thanks Journeyman I'll forward this over to my Lan group. 

Heres a copy of the column in question. 

AUDITTIMESTAMP

1087846893579

1087924923734

1104764681188

1104732392516

1087846893610

1104741005453

1087846893657

1104693744344

1104741246891

1087846893735

I'm using this statement to see the dates, but I can't get it to work with deleting any records over 30 days old.