Advanced Logging - Level 12 of the Stairway to Integration Services

  • Andy Leonard

    SSCrazy Eights

    Points: 9865

    Comments posted to this topic are about the item Advanced Logging - Level 12 of the Stairway to Integration Services

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • dwilliscp

    SSCrazy Eights

    Points: 9241

    Andy,

    I am just about done.... yea. Got a question, are you going to write a level 13 - Batching SSIS Packages? I can already see a good bit of improvement, in our current data load process, but I do not want to have press execute every 15min ... for 24 hours, 7 days a week.

    David

  • Andy Leonard

    SSCrazy Eights

    Points: 9865

    Hi David,

    I have more articles for this series in the pipe, but I would like to know more about your experiences with the series to date and your plans for using what you've learned. If you have the time and do not mind, please email me: andy.leonard@gmail.com.

    Thank you,

    Andy

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • dwilliscp

    SSCrazy Eights

    Points: 9241

    Why does the error log show the date/time twice?

    OnError Script Task 4,{04e1dba6-4a2e-43cb-b9d6-f394c0692a3a},{9CB1DB86-1E0D-4B07-84EC-FEA89DBAAFAD},2/19/2013 4:31:50 PM,2/19/2013 4:31:50 PM,-1001,0x,Script Task 4 failed!

  • dwilliscp

    SSCrazy Eights

    Points: 9241

    Ok, got lost, but I just realized you ment to go back and click SSIS then Logging then Details tab. (Advanced Log Configuration)

  • dwilliscp

    SSCrazy Eights

    Points: 9241

    Hey Andy,

    I wonder if I could talk you into writing an article about Log files. From this series we were just writing everything to the end of the log file. At some point we would want to get rid of the old run info.

    David

  • msiwerr

    Valued Member

    Points: 57

    Hi Andy,

    You forgot to put "DisableEventHandlers" to "False" in the "Parent.dtsx". This will never log in the database if it stays True.

    Thanks.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply