[Ask] Error When Import DB5 To SQL2000...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

[Ask] Error When Import DB5 To SQL2000...

Author

Topic

zhelegour
Starting Member

5 Posts

Posted - 2007-04-26 : 13:10:35

when I do import table from DB5 to SQL, at part proses its error, and the message is there are record was deleted, and then importing proses is cancel, and no one the record is succses to import,

can I import this table without the error??

sory with my English, I am from Indonesia...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 13:14:14

Your problem is not very clear. How are you doing the import? DTS, SSIS, bcp, T-SQL script, ...?

What is DB5?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

zhelegour
Starting Member

5 Posts

Posted - 2007-04-27 : 12:50:02

I Do import with DTS, DB5=dbase5 or FoxBase. this is the problem:
i have table from foxbase, this table have record total about 120.000 record, when I Do importing from foxbase(dbase5) to SQL, at the part importing or executing package this is Error.
the error message : "Errors encountered so far in this task:1. record is deleted. the search key was not found in any record."

Can I do this importing without error and without I must do editing in this Foxbase table???

zhelegour
Starting Member

5 Posts

Posted - 2007-04-27 : 12:54:46

If any One who want to try do import this table, I have Upload the table On www.mediamax.com (username:universe2heaven & password:killbill)

I hope any one want to help me.....

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-27 : 13:02:18

Tried load data via linked server?

zhelegour
Starting Member

5 Posts

Posted - 2007-04-27 : 13:52:53

[