Problem In writing data in SQL Sever 2008

Sat, 19 Jan 2013 07:16:11 GMT

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

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>

</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

Re: Problem In writing data in SQL Sever 2008

Wed, 23 Jan 2013 13:17:00 GMT

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

topic Problem In writing data in SQL Sever 2008 in QlikView

Problem In writing data in SQL Sever 2008

Re: Problem In writing data in SQL Sever 2008