Package Variable

• ramdas.narayanan

  Ten Centuries

  Points: 1214

  More actions

  August 15, 2008 at 11:24 am

  #123026

  Hi Folks,

  I am retrieving a column of type XML from a table, this is part of the execute sql task: and want to store that in a Package Variable in SSIS. What should be the data type of the Package Variable: If i define it as a string, i get an error. Any thoughts...

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 15, 2008 at 12:45 pm

  #858930

  You are returning a xml node - try using a object type variable.

  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!