- Posts: 55
- Thank you received: 8
Repository Update Script Error
3 weeks 2 days ago #22976
by downing
Repository Update Script Error was created by downing
Please Log in or Create an account to join the conversation.
3 weeks 2 days ago #22979
by admin
Mike
ETL Architect
Replied by admin on topic Repository Update Script Error
Please try replacing -10 with some other value for example -33
"OBJECT_ID*-10"
INSERT INTO OBJECTS_TREE (OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select OBJECT_ID*-10 as OBJECT_ID,
PARENT_ID,'Block Transformations' as NAME,
420 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=390
It is good to hear that you found block transformations useful.
We did put a lot of effort into developing it and we have done an enormous amount of testing.
It has a lot of room for improvement though
"OBJECT_ID*-10"
INSERT INTO OBJECTS_TREE (OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select OBJECT_ID*-10 as OBJECT_ID,
PARENT_ID,'Block Transformations' as NAME,
420 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=390
It is good to hear that you found block transformations useful.
We did put a lot of effort into developing it and we have done an enormous amount of testing.
It has a lot of room for improvement though

Mike
ETL Architect
Please Log in or Create an account to join the conversation.
3 weeks 2 days ago #22981
by downing
Replied by downing on topic Repository Update Script Error
Please Log in or Create an account to join the conversation.
3 weeks 2 days ago #22982
by admin
Mike
ETL Architect
Replied by admin on topic Repository Update Script Error
The examples are in the default MS Access repository.
You can copy them across using the repository synchronization wizard.
You can copy them across using the repository synchronization wizard.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
3 weeks 2 days ago #22983
by downing
Replied by downing on topic Repository Update Script Error
Thx Mike worked Great
Never used the Wizard before
Greets Thomas
Never used the Wizard before
Greets Thomas
The following user(s) said Thank You: admin
Please Log in or Create an account to join the conversation.