Importing dbase files into Sql via DTS

[galvin101]

Hi,

I have a number of DTS packages which import data over night into a SQL database, the data is imported from a dbase file

Just recently, one of the packages has been going wrong, and nothing in the package has changed.

When importing it errors when importing and says
"Error Descriptionata for source column 1 ('PCODE') is not available."
"Error Description:Record is deleted."
"Error Description:The search key was not found in any record."

I have tried importing into access but to no joy, I really dont know what the problem and foremost how to fix the problem.

Any one got any ideas??????

cheers

 

[DrSql]

Verfiy if there any changes on dbase side. It looks like some filds have changed. Verify the trasnformation in DTS package.

Dr.Sql
Good Luck.

 

[vongrunt]

This can be corrupted .dbf file - messed up header or premature Ctrl-Z character within record area.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)