开发者

How to create report from SSIS package when its executed?

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 upd开发者_运维百科ate that variable in package configuration so every time you have the records in that table, the report will be generated from SSISLogs.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜