Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: system flow

system flow 2 months 1 week ago #19374

I am working on a project to create detailed object flow documentation.
i start with the Save all objects and process that into some SQL tables
the attached is one of my package.wfp
I want to get the objects and sort them in the general process flow.
I can capture the object name etc, however it is order flow or processing flow i am having issues with.
Looking at the data, i do not see the sort or flow order
can you point it out to me, is it here or in a different table
the capture shows the actual flow

the overall concept is to have an etl moitoring screen, which we have via dbo.queue and dbo.queue_history
but to identify detail packages and code to those packages to make debugging and code searching easy.

essentially I am trying to create documentation of detail packages and their flow as well as the underlying code
Attachments:

Please Log in or Create an account to join the conversation.

system flow 2 months 1 week ago #19375

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7644
  • Karma: 33
  • Thank you received: 427
Why not use the management console for monitoring?

www.etl-tools.com/wiki/aetle/unattended_...n/management_console
Mike

Please Log in or Create an account to join the conversation.

system flow 2 months 1 week ago #19382

Alan

FYI the actual flow is stored in queue_actions table.

www.etl-tools.com/wiki/knowledgebase/repository_tables
Peter Jonson
Support Analist

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 194 guests and one member online