Looking for SSIS project ideas

  • I am learning how to create SSIS packages and I would like to actaully develop something useful in the process.

    Any ideas for an SSIS project that, when finished, would be useful from a DBA perspective?

    I've already created packages to monitor shrinkage, failed backups and login secutiry.

    Any ideas what other kind of information would be useful to report on (again, for DBA purposes)?

    Thank you!

  • I generally use SSIS to move data around. Into and out of databases.

    Perhaps you could do something with exporting data out of the system databases into Excel? Not sure how practical that is, but it would be practice with SSIS.

    - 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

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

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