import data issue

Summary

import data issue

Content

Hi,

I am trying to load data to Essbase using below import statement which works in MAXL editor

import database "APP"."DB" data connect as "TTT" identified by "PPP" using server rules_file "TEST.rul"

to load_buffer with buffer_id 1 on error write to "test.log";

I tried to automate the same using our automation tool which gives below error.

Syntax error near ['" identified by identified by "PPP" using server rules_file "'].

These are direct sql credentials. I am not trying with encrypted schema/password.

Any suggestions on what is missing here