To read data from excel and write that data into database table.
after that i have created a dataflow in which i put readfile operator and set excel file to read.then put a transform operator the put a write table operator.
and set connectivity on transform operator but when i run the workflow it's give following error.
Compile Succeeded!
Executable: etask.exe
Arguments: -x Dataflow3 -d 1 -i 1
dataflow controller - ETASK-0017-N: Using Desktop license for QlikView Expressor Processor; resource utilization limited. (etask.controller)
expressor dataflow execution utility (etask) 3.8.3.23826 n (Build 23826) Dec 11 2012
tblEmp - OPERATOR-0037-S: The connection parameter 'schemaOverride' is not set. (Dataflow3.Step_1)
SQLSTATE:[01000], Code:[5701], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed database context to 'dbTest'.
SQLSTATE:[01000], Code:[5703], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed language setting to us_english.
tblEmp - GEN_ODBC_OP-0029-I: User enabled the property 'createTableIfMissing' for table 'tblEmp'. (Dataflow3.Step_1)
tblEmp - OPERATOR-0050-F: toolId 3.0, name 'tblEmp' - Exception 'OutTableGenericOdbcOpException' occurred in the 'initialize' function. (Dataflow3.Step_1)
tblEmp - GEN_ODBC_OP-0025-A: create table query for table 'tblEmp' failed with the error: 'SQLSTATE:[HY000], Code:[2760], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The specified schema name "tblEmp" either does not exist or you do not have permission to use it.
'. (Dataflow3.Step_1)
tblEmp - OPERATOR-0003-F: toolId 3.0, name 'tblEmp' - the 'initialize' function failed. (Dataflow3.Step_1)
tblEmp - ETOOL-0006-F: operator 3.0, type out-table, name 'tblEmp': etool failed, phase runInitialize. (Dataflow3.Step_1)
