How to validate the file in SQL Server 2000

How to Validate the .txt, .xls, .mdb, .doc file in SQL SERVER 2000?

If anybody knows, I would appreciate help?

Thanks

hi,

what do you mean validate. Does it mean that file exist? or file is not damage?

please be more specific

thanks

joey

|||

Hi,

Thanks for reply.

I have file .txt,.xls,.mdb,.doc file. I want to load and validate that file format in SQL 2000. I have to do Data Transformation in SQL 2000.

I have different different file of .txt (meaning data is not consistent) and I want to make one fixed format (for consistency of data) for .txt (same way for .xls,.doc and .mdb).

So, I want to validate that file, how I can validate it?

I really appreciate your help and suggestion.

Thanks

|||

hi,

are you referring to the validity of data ?

or the validity of the file system ?

if you are referring to the validity of data

there is no easy way of doing this but

inspecting the files on your own.

if you want to make your task easier

what you can do is to load the data into a staging table

in Sql server. do the cleansing of the data using tsql update, delete

when your done cleansing the data in the staging table

you can then load it to your production table

regards,

joey