Dynamic Data Flow vs Dynamic Select * into to move fact tables.

• Rem70Rem

  SSCertifiable

  Points: 6166

  More actions

  March 9, 2015 at 2:39 pm

  #305597

  Hi,

  I am looking at a way to move data using dynamic data flow. We are moving table between databases often, and never the same set of tables. I have in a control table all tables that need to move together, some time its only 1 table and some other time it can be 40.

  I am trying to use the the data flow, but I am not succeeding . Can the data flow be dynamic?

  For now, I wrote set of store procedures that use dynamic "select * into..." and move only the table(s) passed as parameters. This work well, but I am trying to find better solutions.

  All help/input will be appreciated.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  March 9, 2015 at 3:49 pm

  #1782720

  No, the data flow cannot be dynamic. It needs fixed metadata.

  There are commercial components out there that can handle changing metadata.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP