DSXchange

HI! WE ALMOST FINISHED A DWH PROJECT AND WE WANT TO CLEAN ALL THE HASH FILES WE CREATE ON THE DEVELOPMENT PHASE AND BEFORE WE MOVE TO PRODUCTION. IS THERE A WAY TO DELETE ALL THE FILES IN AND ACCOUNT OR WE NEED TO DELETE ONE BY ONE (EVEN SOMEONES DONT HAVE THE NAME) ANY IDEA WILL BE APPRECIATED!!!

REGARDS,

AV

Are you shouting at us
Just kidding
A friendly reminder, dont use caps. Our posters consider that as shouting.
As for your question, do a search. This topic has been covered here before.
Click here for a start.

Just create a new project, export/import the jobs, and drop the old project

Pretty Smart Ken.

Excellent Ken, Thank you! One more question If I have some hash files identified and we want this in the new project what its the best practice to import to our new project (hash cleaned)... obviuosly we want to conseved it because takes a a long time to porcess this, we dont know may be with a flat file and reload it into the new one?

Any ideas???

Regards...

Take this opportunity to switch to using externally pathed hashed files to a specified directory, you won't have this problem anymore. If you have persistent large hashed files, that another issue. You could write a job to transfer the hashed file from the project to a directory using the opportunity to size the persistent hashed file appropriately.