dbTalk Databases Forums  

Error to open a package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error to open a package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eduardo Greco
 
Posts: n/a

Default Error to open a package - 08-03-2004 , 06:04 AM






Hi there...
I've been working on a package and when I tried to open it today I got the
following error:
"Page (1:2805), slot 3 for text, ntext, or image node does not exist"
Why is this happening? How to correct it?
Is there any possibility to restore or recover some parts of my package?
Thanks for helping...
Eduardo



Reply With Quote
  #2  
Old   
Jacco Schalkwijk
 
Posts: n/a

Default Re: Error to open a package - 08-03-2004 , 12:31 PM






DTS packages, when stored on SQL Server, are stored in the msdb database.
From the error message, it looks like you have some corruption in the msdb
database. Try running DBCC CHECKDB on the database and see if it will fix
the problem, or restore your msdb database from a backup. Make sure to
backup the msdb database before you run DBCC CHECKDB.

--
Jacco Schalkwijk
SQL Server MVP


"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

Quote:
Hi there...
I've been working on a package and when I tried to open it today I got the
following error:
"Page (1:2805), slot 3 for text, ntext, or image node does not exist"
Why is this happening? How to correct it?
Is there any possibility to restore or recover some parts of my package?
Thanks for helping...
Eduardo





Reply With Quote
  #3  
Old   
Darren Green
 
Posts: n/a

Default Re: Error to open a package - 08-03-2004 , 05:35 PM



In message <OOZBvpWeEHA.236 (AT) tk2msftngp13 (DOT) phx.gbl>, Eduardo Greco
<eduardo (AT) persocom (DOT) com.br> writes
Quote:
Hi there...
I've been working on a package and when I tried to open it today I got the
following error:
"Page (1:2805), slot 3 for text, ntext, or image node does not exist"
Why is this happening? How to correct it?
Is there any possibility to restore or recover some parts of my package?
Thanks for helping...
Eduardo


As Jacco suggest, this is a problem with SQL, not specifically DTS.

A few links from the archives may help-

http://tinyurl.com/6vxya

http://tinyurl.com/7yld6


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.