how to replace integer with numeric in all the jobs/few jobs

[RAJEEV KATTA]

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.

[ArndW]

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.