SSIS Teradata - Unable to parse volatile table creation
<p>I have 3 parts to a teradata query</p>

<pre><code>CREATE MULTISET VOLATILE TABLE ...
SELECT QUERY -- Using the volatile table
DROP TABLE -- Volatile table
</code></pre>

<p>Works fine in Teradata SQL assistant,</p>

<p>Throws me an error <strong>Data definition not valid unless solitary</strong> in SSIS Data Flow task when I execute this using <code>SQL command using variable</code></p>

<p>Any way to resolve this issue? Other than creating a gtt table in Teradata space and using it.</p>