Results 1 to 3 of 3

Thread: DTS Progress Logging

  1. 11-22-2002, 10:26 AM #1
    MrBaseball34
    MrBaseball34 is offline Registered User
    Join Date
    Nov 2002
    Posts
    2

    DTS Progress Logging

    I need to logg progress of a DTS job. How do I do that? I'd like the progress to be stored in a file and emailed to me.

    I need to track progress of the transfer of each table in two databases.
    Reply With Quote Reply With Quote
  2. 11-22-2002, 02:50 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can set package level property to log all activities to a file.

    Just open the package designer and use properties from file menu.
    Reply With Quote Reply With Quote
  3. 11-22-2002, 02:53 PM #3
    MrBaseball34
    MrBaseball34 is offline Registered User
    Join Date
    Nov 2002
    Posts
    2
    Does this logg each "transaction" like which table it is transfering and how many records it transfers, successes and failures?

    Know how to set a timeout on a DTS package?

    We have a VPN and it gets flaky sometimes and our DTS package can possibly run into a situation where the VPN goes down during a transfer. We have the VPN redial set at 3 sec.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules