ETL and Data Integration tools - Modern ETL software for everyone

Hi,

We are currently using the version 7.6.7.0 of visual data importer.

When I try to use the next version I can open the repository from a
backup but the packages cannot be seen and it hangs.

Thanks for your help,

Best Regards,

S Cantera

Old version

Run the script below against your access repository

that should fix it

ALTER TABLE connections ADD COLUMN PORT number
GO
update objects_tree set object_type=100 where parent_id=-1
GO
update objects_tree set object_type=321 where parent_id=2 and object_type=0
GO
update objects_tree set object_type=331 where parent_id=1 and object_type=0
GO
update objects_tree set object_type=341 where parent_id=3 and object_type=0
GO
update objects_tree set object_type=330 where object_type=-1
GO
update objects_tree set object_type=320 where object_type=-2
GO
update objects_tree set object_type=340 where object_type=-3
GO
update objects_tree set object_type=800 where object_type=3 and parent_id=0
GO
update objects_tree set object_type=811 where object_type=3
GO
update objects_tree set object_type=310 where object_type=4 and parent_id=0
GO
update objects_tree set object_type=311 where object_type=4
GO
update objects_tree set object_type=511 where object_type=2
GO
update objects_tree set object_type=421 where object_type=1
GO
update objects_tree set object_type=431 where object_type=6
GO
update objects_tree set object_type=441 where object_type=5
GO

update connections set connection_type=311 where connection_type=0
GO

insert into objects_tree (object_id,parent_id,name,object_type)
values (342,0,'MySql',342)
GO
insert into objects_tree (object_id,parent_id,name,object_type)
values (344,0,'PostgreSQL',344)
GO
insert into objects_tree (object_id,parent_id,name,object_type)
values (346,0,'Interbase',346)
GO
insert into objects_tree (object_id,parent_id,name,object_type)
values (338,0,'OleDB',338)
GO


Mike