One of the requirements is to write all the data processed on the dataflow to a qvd file. Is this possible?
Not yet - this is on the roadmap for a future rlease. The current extension you must set is .qvx when using the Write QlikView operator.
Currently QVE - can only read .QVX files that were generated by QVE itself. There is discussion about reading in other generated .QVX and .QVD files.
Another requirement is to read a table and then split or take 1 field and write all of its data on a MSSQL table and take the other field in a csv file.
My question is: The rule on the transformation operator is the only way to do this (Blocking the second field)
This can be done with a Copy Operator and two Transform Operators - where each one block a different field.
If I could create a table on my MSSQL database with the write table operator in Expressor, or I have to do it before on my database server. (Asume that the Connection to SQL server gives me administrator permissions)
Yes you can click the CREATE TABLE check box on the WRITE TABLE operator properties that will allow you to do this. As long as you have permissions - the DDL will be generated to do so.
See attached sample (import into QVE using Import functionality DO NOT UNZIP) and screen shot:
I created this with QVE 3.8 - should be available EOD today - but this may work if you import into 3.7.1.
The data files will be available here after you import it:
<drive: workspace path>\Metadata\Split.0\dfp\Dataflow1\external
Note you workspace path will vary.