I have a DTS package that suddenly failed after running
successfully for over a month. SQL SP3 is installed for
all instances. Any ideas would be helpful. Thanks Bob

And I presume 208 is the error?

208 means "Invalid Object Name"

Has anything been removed/renamed?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Bob" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Nothing has been changed to my knowledge and all named
objects appear correct

Yes 208 is the Event ID

Oh OK.

In the package enable logging to a text file and tell us what the longer
version of the error is.
Is this in a job? If yes then have the job log errors as well.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Bob" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Her's one error log:
Executed as user: RAPATTONI-2\SYSTEM. ...rt: Drop table
[silvardb].[silvar].[Member] Step DTSRun OnFinish: Drop
table [silvardb].[silvar].[Member] Step DTSRun OnStart:
Create Table [silvardb].[silvar].[Member] Step DTSRun
OnFinish: Create Table [silvardb].[silvar].[Member]
Step DTSRun OnStart: Copy Data from Member to
[silvardb].[silvar].[Member] Step DTSRun OnProgress:
Copy Data from Member to [silvardb].[silvar].[Member]
Step; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun
OnError: Copy Data from Member to [silvardb].[silvar].
[Member] Step, Error = -2147467259 (80004005) Error
string: Error at Destination for Row number 1165. Errors
encountered so far in this task: 1. Error source:
DTS Data Pump Help file: Help context: 0
Error Detail Records: Error: -2147467259 (80004005);
Provider Error: 11 (B) Error string: [DBNETLIB]
[ConnectionWrite (send()).]General ne... Process Exit
Code 1. The step failed.

This is from the job step. Do you have the DTS log?

The error number 80004005 would suggest to me one of two things

1. Permissions are incorrect
2. The object you want to use is not available/cannot be seen.
(Error string: [DBNETLIB] [ConnectionWrite (send()).]General ne......)



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Bob" <anonymous (AT) discussions (DOT) microsoft.com> wrote