miércoles, 25 de julio de 2012 15:12
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!
Todas las respuestas
miércoles, 25 de julio de 2012 17:23Moderador
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.
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
jueves, 26 de julio de 2012 13:44Thanks 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.