Creating reports for SSIS packages

  • I want to create reports which list the results of SSIS packages in SQL 2008. The reports would include the number or rows loaded, success of packages, filesloaded and other descriptive information. Is this accomplished thru logging?

  • Yes, you'd need to log that data to report against it.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Enable logging in advanced options you can click text or flat file thats it.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

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