Hi,
Can someone explain why DTS package failed because no related error message
shows on the view job history? I have 2 database copies to secondary site,
this one failed but another is OK. Please see details as following:

Executed as user: CRPA-WEB1\jyu. ...OnStart: Drop table
[MembersReporting].[dbo].[BESTEXEC] Step DTSRun OnStart: Drop table
[MembersReporting].[dbo].[Board_Meeting_Dates] Step DTSRun OnStart: Drop
table [MembersReporting].[dbo].[BIN_PROFILE] Step DTSRun OnStart: Drop
table [MembersReporting].[dbo].[APPLICATIONS] Step DTSRun OnFinish: Drop
table [MembersReporting].[dbo].[BESTEXEC] Step DTSRun OnStart: Create
Table [MembersReporting].[dbo].[BESTEXEC] Step DTSRun OnFinish: Drop table
[MembersReporting].[dbo].[APPLICATIONS] Step DTSRun OnStart: Create Table
[MembersReporting].[dbo].[APPLICATIONS] Step DTSRun OnFinish: Drop table
[MembersReporting].[dbo].[Board_Meeting_Dates] Step DTSRun OnStart: Create
Table [MembersReporting].[dbo].[Board_Meeting_Dates] Step DTSRun OnFinish:
Create Table [MembersReporting].[dbo].[BESTEXEC] Step DTSRun OnFinish:
Drop table [MembersReporting].[dbo].[BIN_PROFILE] Step DTSRun OnStart:
Copy Data from BE... Process Exit Code 2. The step failed.

Regards!
Chen

Chen:

You may want to turn on Package Logging on the DTS Package that is failing
to see if you can get an error message there. Open DTS Package, get to the
Package Properties, Logging tab and turn it on to log to your SQL server
instance. Next time it fails, right click on the DTS Package (not the job)
and choose Package Log... That should give you more info on what is going
on.

Scott

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

Hi Scott,

Thanks for your reply. While I right click Data Transformation Service go to
Package Properties, it only shows one General tab, the option are Turn on
cache, Show multi-phase pump in DTS designer, Turn on just-in-time debugging,
and Enable Save To Meta Data Services. No Loggin tab shows in Properties.
Actually, the version of SQL Server has been installed SQL Server Standard
Edition with SP4.
Any other methods generate logs?

Thanks!
Chen

"Wm. Scott Miller" wrote:

The problem with the Agent logging in that window is that it has a limit
as to how much it logs.

The logs for a DTS package are in the package itself so

open your package | right click on the designer whitespace | Package
properties | Logging tab

You also get a log for the datapump task which you can specify on the
last tab of the data pump setup.

Allan

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