In article <ehohU$AXDHA.1580 (AT) tk2msftngp13 (DOT) phx.gbl>, Pradeep
<pradeepd (AT) msn (DOT) com> writes
How are you executing the package? Manually in Enterprise Manager,
though a SQL Server Agent job or some other method?
At what stage do you get the error and from where do you get the error
details? Is that the full error message?

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

Hi Daren,

I run the DTS package from Enterprise Manager.

The Full error message

"Error at Destination for Row number 549. Errors encountered so far in this
task: 1. The server could not load DCOM."

and when we try to write error log in to file, this is the content of the
log generated..

DATA TRANSFORMATION SERVICES: Data Pump Exception Log
Package Name: (null)
Package Description: (null)
Package ID: {EF0BDB34-121D-4447-B926-4E0308708B1A}
Package Version: {EF0BDB34-121D-4447-B926-4E0308708B1A}
Step Name: <DTS Testing Transform Task>xecution Started: 8/6/2003 2:05:05 PM
Error at Destination for Row number 549. Errors encountered so far in this
task: 1.

Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:The server could not load DCOM.
Error Help File:
Error Help Context ID:0

Execution Completed: 8/6/2003 2:05:06 PM

************************************************** **************************
************************

Execution Started: 8/6/2003 2:08:43 PM
Execution Completed: 8/6/2003 2:08:43 PM

************************************************** **************************
************************

daren, can you help me out in this issue.

regards
Pradeep

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:bL4irgQnjVMicrosoftEwWp (AT) sqldts (DOT) com...