DSXchange

I have a scenario where in I need to replace integer datatype fields with numeric datatype.I thought to replace it from schema file but in the backend for integer its int32 and for numeric its decimal[p,s].All the fields have different lengths so I can't do that.Is there any way where in we can replace just integer in the jobs with numeric or is there any tool which can do that.

Such global actions can often be done by editing a .dsx export file and using macros or other tools to make the necessary changes. Note that this could potentially destroy a project, so needs to be done carefully and with backup of the existing project contents.