Hi,
for a my SSIS 2012/2014 project, I need to create a new table from a template one operating necessarily inside a data flow task (where I need to use a multicast component to obtain the name of the new table to create).
I'v tried to use an OLE DB Command component to call a stored procedure that launches a dynamic SELECT * INTO NewTable FROM TemplateTabl, performed by an EXEC statement: the excution of the OLE DB Command functions normally, but any new tables is not created.
How could I solve it with OLE DB Command? Or with another component operating inside the data flow task?
Many thanks