Home Forums Data Warehousing Integration Services Need help with simple ETL strategy with SSIS RE: Need help with simple ETL strategy with SSIS

  • October 20, 2013 at 11:13 pm

    #1660024

    Koen Verbeeck (10/20/2013)

    In contrast with Jeff, I know (quite) a lot about SSIS.

    DO NOT USE SSIS FOR THIS.

    Use dynamic SQL for this (as Jeff mentioned).

    If I would need to do this in SSIS, I would do it with dynamic SQL in an Execute SQL Task.

    (alternatively, you could also use the .NET SQLBulkCopy class in a Script Task)

    Yes, thats what I am doing now. Dynamic SQL inside SSIS. So time consuming !