How to create report from SSIS package when its executed?

Question

Hi All,

I have an SSIS package that loads data in a table. How do I create a report from that table every time the package would run?

NOTE : I asked somebody about this issue and this is what he told me:

Create a variable called SSISReport and update that variable in package configuration so every time you have the records in that table, the report will be generated from SSISLogs.

**I DIDN'T UNDERSTAND THAT CLEARLY. CAN SOMEBODY TELL ME EXACTLY WHAT I HAVE TO DO?

THANKS

Answer 1

I have a logs table in my database and a sp_ that inserts rows into it. When the package starts, I delete all the existing records in the log table. Before each action in the package, I call my sp with a comment describing what I'm about to do in the package. After the last package action, I call the sp again saying it's done.

The log table has a timestamp so I can see the last time the package ran successfully and how long each step took.

There are other ways to do logging in SSIS, but I don't have admin access anywhere, so I created my own table.

HTH