How to realize cross apply in XML source in ssis 2008

• max_zhou

  SSC Journeyman

  Points: 80

  More actions

  February 19, 2010 at 12:12 pm

  #219332

  Hi I have a XML source and need use 'CROSS APPLY', anybody has idea how to do in SSIS and don't use query ?

  like

  FROM [xmlImport] CROSS APPLY msg.nodes('/A/B/C') AS R(nref)

  thanks