Kip Real
Reputation: 3469
What is the use of sp_addextendedproperty in SSIS packages?
How to use sp_addextendedproperty for package audit
Upvotes: 0
Views: 313
Answers (1)
Kip Real
Reputation: 3469
sp_addextendedproperty adds a new extended property to a database object and can be use in SSIS to create an Audit trail by adding package name, time it was run and count of rows deleted or updated during an ETL process
Upvotes: 1
Related Questions
- What is the SSIS package and what does it do?
- How does Visual Studio SSIS Handle Extensions and Package Deployment?
- SSIS 2008: Can a package configuration contain a property not used by the package?
- Can you explain the use of sys.sp_addextendedproperty in the following code?
- Understanding Stored Packages on Integration Services
- Why would you set the Package Configurations in SSIS VS over SSMS Run Time?
- SSIS Package Configuration - where to set variable property
- SQL - Server - What is sp_addextendedproperty commonly used for, and is it likely this code (see) is auto generated?
- Whats are the advantages/disadvantages of different package configuration in ssis
- help needed on SSIS package concept