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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-25 : 09:46:49
|
| Ellen writes "Hello together,I've an interessting problem and i need help from experts.Our systemcomponents are Windows 2000 (SP 2)SQL Server 7 (SP 4)I've written an stored procedure, which will (should) fill a table with near 150.000 rows.The SP is running successfully.When i take it in an DTS package, the package is running and during the execution the process it dies and the enterprise manager closed by himself. the table was filled by ca. 20.000 rows ...I've many other DTS Package created all are working fine - but here is a poblem i can't find.the dts has only the execution of the stored procedure.Has anybody an idea where the problem can be ?Or what i can try ?thanks for all help or for ideas !!!GreetingsEllen"<edit>cleaned up some display quirks</edit>Edited by - robvolk on 07/25/2002 09:47:56 |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2002-07-25 : 10:00:44
|
| Hi,Set up a trace using the SQL profiler and execute the DTS package, this would enable to find when the DTS package stops.Hope this points you in the right direction.ByeRamdasRamdas NarayananSQL Server DBA |
 |
|
|
|
|
|
DTS PROBLEM PROCESS DIE DURING EXECUTING