Hello everyone.
I'm posting this here because I found it somewhat hard to write to SqLite file databases.
Now I've figured out a way, it's working fine.
I'm not sure that it's the correct path, but I'm sharing my way :
- drag an output data tool,
- select options:
File Format: "SQlite (*.sqlite)"
Output Options: "Delete Data & Append"
Pre Create SQL Statement: "CREATE TABLE IF NOT EXISTS Dim... "
- name the file after the desired filename + PIPES + THE DESIRED TABLE NAME
"OlympicMedals.sqlite|||DimAthlete"
- copy & paste the output tool, repeat the process for each table
- adjust the pre create SQL code
- change the table name after the pipes
thanks,
Michael.
Solved! Go to Solution.
@Michael_S this looks fine to me.