Creating a SQL Server table inside a data flow task - SSIS 2012 and superior

  • 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

  • pmscorca - Sunday, March 26, 2017 3:27 PM

    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

    I would be seeking to populate a package variable with the table name coming out of the result set in the multicast.  Then I'd have to construct dynamic SQL that uses that variable name as part of the query.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply