Saving results of XML query. PLEASE tell me there''s a way in 2005

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 10, 2006 at 2:55 pm

  #167733

  Hi All,

  Does anyone know if there is a way to save the results of a XML query using SSIS?

  Exporting to a flat file does not work as the result of the query is DT_IMAGE.

   

  I do not want to use the old work around of having a VB app / script which loads the stream and then writes it out or the "BCP your query out"

  I cannot convert the DT_IMAGE to any form of data that can be written out.

  The closest I could get is to convert it to a text stream but from there it gets lost.

   

  Please tell me MS has put in a nice XML DESTINATION which I just can't see.

  Something that can just plain and simple open a text file and stream the data into it.

  PLEASE PLEASE PLEASE tell me there's something...

   

  Waited with baited breath...

   

   

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 11, 2006 at 6:42 am

  #614042

  Anyone? has MS forgotten about us again?

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!