Audit table
Hello everyone,
I want an audit table in my database where all the information about the package is there in that audit table.
Is there is any tool present in SSIS by the help of which i can do this auditing .
Please provide some link or example or any suggestion for resolving this problem.
July 7th, 2011 2:07pm
What kind of an audit data do you need?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 2:12pm
See if these three satisfy your needs:
sysdtslog90 (Transact-SQL)
Contains one row for each log entry that a SSIS package generates at run time.
sysdtspackagefolders90 (Transact-SQL)
Contains one row for each folder that the Integration Services service uses. Column values define the parent/child relationship between folders.
sysdtspackages90 (Transact-SQL)
Contains a row for each SSIS package.
Arthur My Blog
July 7th, 2011 2:14pm
This topic is archived. No further replies will be accepted.
Other recent topics
