too many fields defined

[sarahw]

I am trying to import old dbase files into sqlserver 2000 using dts. I have 2 problems with this:

1. 1 table produces the error 'too many fields defined' - I also get this message when importing into access.

2. Many of the tables have separate date and time columns - sql server does not like the timestamp data type. I know that it is possible to write a transformation script in vb, but I'm not familiar with this.

Does anyone have some code that could show me how to check for a valid date and if not enter some generic date and then combine the date and time columns.

Many thanks
Sarah

 

[Liberty]

Is there any way you can put the data from dbase to a txt file and then import it to sql server. It works fine with txt files.