Ever need to view/edit a DTM job outside of DTM? Why would you need to do that, you ask? It may be helpful to edit a job file outside DTM when:
- The destination or source is not online or reachable (such as troubleshooting the file remotely when a customer sends you thier job file).
- You need to make an edit to a script transform that the DTM editor will not allow even though it is a valid operation.
- You're just plain nosey.
The DTM job file (.dtmconfig) is a dataset serialized into an XML file. Visual Studio 2003 (and 2005, though I have not tested it) can edit the XML file as a dataset if it know it is an XML file. Just rename the job file to the .xml extension and open it in VS2003. Click the Data tab and VS will show a simple graphical view of each table in the dataset. There are four tables:
- SourceSchema - list of the source field names
- FieldMap - maping of source to destination, transforms are in here too.
- DestinationSchema - list of the destination field names
- Settings - Connection settings and Global Scripting Editor scripts. Passwords are encrypted.
See the attached screenshot for an example.
Some things to remember:
- VS2003 will not do any validation on your changes. You could break the file so DTM is unable to use it.
- Don't forget to rename the file back to .dtmconfig.
- Job files are stored in the followin folder:
C:\Documents and Settings\All Users\Application Data\Imanami\DTM3\jobs
Enjoy!