Projects created by SSIS packages

Question

All,

      In the SSIS packages that I'm creating, I'm using DQS cleansing and a conditional splitter to move Corrected, Auto suggest and Invalid records into tables that will be later used for reports.  So I'm getting the data I need without the use of creating projects within the DQS client.

      However, each time I run my SSIS packages I notice new projects in the DQS client.  These new projects are automatically created each time I execute my SSIS package that uses the DQS Cleansing control. 

      So my question is .....how do I programmatically remove projects that are automatically generated by my SSIS packages that uses the DQS cleansing control?  I would like to delete these projects so that disk space does not become an issue over time.

Thanks for any help!

Answer 1

I'll raise the concern here at Microsoft and see if anyone has a good idea on how to solve the problem.

SQL 2012 RTM Cumulative Update 2 does help reduce the table size for projects, so make sure to use that meanwhile.

http://support.microsoft.com/kb/2685743/

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 2

Thanks Jason!  I have applied the cumulative update 2 nearly two weeks ago.  Please let me know if there is a solution to autmatically delete DQS projects.