1 Reply Latest reply: Jan 23, 2013 8:17 AM by Daniel Ohlsson RSS

    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