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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-08-04 : 09:44:07
|
| Hi all,I am trying to get data through DTS and after transfering around 651K it gives me Exception Access Violation and it fails to transfer data there is more than millions records in the table!!what is the solution for this please!!!! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-04 : 10:15:19
|
| Do you have the latest sql server service pack applied to bothe the server and (more importantly) the client machine?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-04 : 14:46:36
|
| yes i have applied SP4 on thatthanks |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-09 : 12:42:39
|
| I am trying to get data through DTS and after transfering around 651K it gives me Exception Access Violation and it fails to transfer data there is more than millions records in the table!!what is the solution for this please!!!! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-09 : 15:42:56
|
quote:
Originally posted by PatDeV
I am trying to get data through DTS and after transfering around 651K it gives me Exception Access Violation and it fails to transfer data there is more than millions records in the table!!what is the solution for this please!!!!
I wonder if you have some kind of data corruption. Have you run a DBCC CHECKDB on the database(s)?-ec |
|
|
|
|
|
|
Error whilde doing DTS!!!!