dbTalk Databases Forums  

Track a flow of DTS

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


Discuss Track a flow of DTS in the microsoft.public.sqlserver.dts forum.



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

Default Track a flow of DTS - 06-23-2006 , 12:23 PM






Good afternoon to all!

I am starting to work with DW and SQL 2000 together with Analysis
Server and am needing to know if it is possible and as to make to track
a flow of dts to be able to identify, when to give problem, in which
stage occurred the problem.

Thanks!


Reply With Quote
  #2  
Old   
Peter
 
Posts: n/a

Default RE: Track a flow of DTS - 06-26-2006 , 04:37 PM






I do not understand you completely.

You could schedule the DTS package for 5 minutes in the future, then look at
the results of the Job (EM > Management > SQL Server Agent > Jobs). There
will be a red X by the job if it failed. You can right click the job, select
"View Job History", check the Show step details box, then highlight each of
the steps in the job. Errors and messages will appear in the bottom window.

"Rainier" wrote:

Quote:
Good afternoon to all!

I am starting to work with DW and SQL 2000 together with Analysis
Server and am needing to know if it is possible and as to make to track
a flow of dts to be able to identify, when to give problem, in which
stage occurred the problem.

Thanks!



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.