Advanced Logging - Level 12 of the Stairway to Integration Services

Question

Advanced Logging - Level 12 of the Stairway to Integration Services

Andy Leonard

SSChampion

Points: 10144
More actions
February 6, 2013 at 12:06 am

#270296

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

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

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

dwilliscp SSCrazy Eights Points: 9270 More actions · Answer 1

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 SSChampion Points: 10144 More actions · Answer 2

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: 9270 More actions · Answer 3

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: 9270 More actions · Answer 4

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: 9270 More actions · Answer 5

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 More actions · Answer 6

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.