This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
On the output data component, when outputting to a database, there are Pre & Post Create SQL statement switches. This allows for the execution of a SQL statement in the DB but only after a create table action. To use this functionality you must have populated a table using the 'create new table' or 'overwrite' option, which is no good if you're using the Update or Append options. Change these switches to Pre & Post SQL Statements as per the Input Data component. This will allow you to execute SQL statements in the DB either before or after the population action. Can be really handy if you need to execute database stored procedures for example.
Please note: You can already work around this by branching from your data stream and creating or overwriting a dummy table, then use the pre or post create switch for your SQL statement. This is a bit messy and can leave dummy tables in the DB, which is a bit scruffy.