HomeForum
Welcome, Guest

Not able to create new data transformation project
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Not able to create new data transformation project

Not able to create new data transformation project 1 year, 8 months ago #1002

  • Cliff
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hi

I have just installed latest version Advanced ETL Processor and am no longer able to create new projects

Any help would be much appreciated

Cliff

Re:Not able to create new data transformation project 1 year, 8 months ago #1003

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2174
  • Karma: 12
I see

Shut down AETL

Run this SQL against the repository

INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (348,'SQLite')
GO
INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (349,'SQLite Connection')
GO
Insert into OBJECTS_TREE
(OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select
-OBJECTS_TREE.OBJECT_ID as OBJECT_ID,
OBJECTS_TREE.OBJECT_ID as PARENT_ID,
'SQLite' as NAME,
348 as OBJECT_TYPE
From
OBJECTS_TREE
Where
OBJECTS_TREE.OBJECT_TYPE = 300

This will enable support for SQLite and sort out project creation problem

Mike
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

If we compare to manual processing this program save more than 200 hours in month.

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top