Dynamically create a table in an SSIS data stream

Question

How can I create an SSIS data stream to create a table that does not exist? Every time I try to run a package, it gives me an error saying that the destination table does not exist.

Answer 1

Since you want your package to create a table and then populate it, you can create it using the Execute SQL task. Just let the script create the table.

If you cannot use the Execute SQL or Script task, you can use the Script component, but since it is executed for each row, you will need to make an announcement so that it runs only once.

In addition, when you run this package, SSIS is about to trim the table not found during validation.

To take into account that in the properties of the package in the data stream that populates the table, set the Delay Validation property to True

Answer 2

Why not create a table in the step before the data stream in the execution of the SQL task?