Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I hav created a excel schema and table schema.
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
<task dataflow="Dataflow3">
<!-- project.home[(null)], project[..] -->
<step id="0" step_name="Step_1" process="6272" run="0" status="ok" start="2013-01-19T12:14:59">
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)
tblEmp - ETOOL-0016-A: operator 3.0, type out-table, pid 6184 - initialize() failed. (Dataflow3.Step_1)
<status>failed</status>
</step>
<statistic>0.141</statistic>
</task>
dataflow controller - ETASK-0038-F: Processing has completed abnormally. (Dataflow3.controller)
Please help as soon as possible to get it work.
I am also attaching my files for that
Or please describe steps to read data from excel and write into sql sever 2008 tables from start.
Thanks
Hi. You can read the excel data into QlikView, and then for example use a macro to writ to the DB.
See this post for more information: http://community.qlik.com/message/135858