DI Studio SQL Insert how do 1 stop map all fields from Source

[JonT]

I have a table of hundreds of columns, and I only want 4. How do I stop the mass mapping?

DI 4.903

[jklaverstijn · Accepted solution]

Hi,

Yes the automatic propagation is a royal pain.

You can turn it off in your job: rght-click on the cvanvas and choose Automation Settings --> Automatically Propagate Columns. Do the same for Automatically Map Columns.

The default for any new job is set in Tools --> Options --> Job Editor tab. There are some settings grouped in a box called "Automatic Settings". There you can turn off automattic column mapping and propagation permanently.

Hope this helps,
-- Jan.

[JonT]

Jan

Thank you!

Ive actually been on the fast track DI course, but the difference between course data designed for DI and Real World data is stumping me!

[AngusLooney]

Yup, switch it off ASAP, in the real world it's not what you usually want.