Skip to Content
0

Table mapping - source object change

6 days ago

22

avatar image

Hello,

is there any way how to change the source object of Table Mapping? I need to switch the source object of already existing mapping to a new source table (with exactly same set of columns). With my model (see image 01)

I tried following:

Changing the TargetObject of the shortcut representing the source table in the target model was not enough (see image 02, missing lines, source table in the mapping Unavailable).

sourceTab.ChangeTargetObject NewSourceTable

So I tried inserting new source model into the SourceModels collection of the appropriate DataSource first (=creates new source model in the TargetModels collection) and manually creating the shortcut of new source table into the target model. Result was the same, none of these helped (see image 02).

ds.SourceModels.Insert -1, newSourceMdl
Set newShortcut = newSourceTable.CreateShortcut(Mapping.Package)
sourceTab.ChangeTargetObject NewSourceTable

So my question is, is it possible to change the source table of a TableMapping from one source table to another (in different model)? Or do I have to duplicate the TableMapping with new source and then delete the original mapping? How to deal with ColumnMappings if I succeed with the TableMapping? They will/should be gone when I modify the parent object.

Thanks in advance for any advice,

Ondrej

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers