We are using the DQS shape in SSIS and have run a few hundred SSIS packages that perform validation and correction.
When I go into the DQS client I can see a "Data Quality Project" has been created for every single execution of the SSIS package.
How do I prevent SSIS from creating a Data Quality Project or clean-up the unwanted projects ?
You can use the TSQL script mentioned in this article to automate the cleanup of Data Quality Projects created by SSIS for a certain date range:
TSQL Script to delete DQS projects leftover from SSIS DQS Cleansing component.
(SQL Server Documentation | Twitter:
NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.
Thx Vivek. That's just what I was looking for.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?