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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-09-15 : 09:29:54
|
| Hi Folks,I am using DTS in SQL server 2000 to export data from table and import into an another table in the same sql server 2000 database. Data fro Table_a is moved to Table_a_archive based on a date criteria. There are 10 mill rows satisfying this criteria. when Run the task in DTS close to completion I get the following error message.Warning: Fatal error 3624 occurredLocation: somerge.c:2808Expression: sortdesP->soTimerActiveSPID: 67Process ID: 258Any thoughts, this package has only one data transformation task, there are only 5 columns in the table all of them mappped one to one.ThanksRamdasRamdas NarayananSQL Server DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-15 : 09:47:54
|
| Are you running lots of packages at once?What's the service pack level?-------Moo. :) |
 |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2003-09-15 : 09:54:16
|
| Hi,I am running only one package, the service pack level is the latest service pack for sql server 2000.Ramdas NarayananRamdas NarayananSQL Server DBA |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-15 : 11:12:13
|
| Looks like one of those assertion thingymagigs. We got a few of them when DTSing large amounts of data. Check your log files. If it is an assertion failure you can report it to microsoft as a bug, I think.-------Moo. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-15 : 12:16:43
|
| Why are you using DTS for this? Why not use INSERT INTO/SELECT FROM? DTS really shouldn't be used for things that can be accomplished with pure T-SQL.Tara |
|
|
|
|
|
|
DTS Error