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.
| Author |
Topic |
|
shzkhan28
Starting Member
15 Posts |
 Posted - 2009-07-09 : 06:58:50
|
| Hi All,I am importing from FoxPro Table to SQL Serverin DTS it show 100 records uploaded,but when i chk that table with select cmd there only one record?Can any one Know the causeThanks... |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-09 : 07:15:52
|
Hi,I am not doing a joke.Are you very sure you are looking in the right DATABASE.SCHEMA.TABLE to check the result?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
shzkhan28
Starting Member
15 Posts |
Posted - 2009-07-09 : 08:16:48
|
| Yes,i am looking at right tableActually this is SQL 2000 mdf and i trying to Import FoxPro Table to itvia SQL 2005 DTS |
|
|
|
shzkhan28
Starting Member
15 Posts |
Posted - 2009-07-09 : 08:37:14
|
| Ok,job done when i try to Import from SQL 2000 DTS |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-09 : 09:17:54
|
That's fine 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Import only one record in SQL Table