Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem In writing data in SQL Sever 2008

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

1 Reply
Not applicable
Author

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