No column information was returned by SQL command when executing MXD query in SSIS Source Editor

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  August 23, 2016 at 12:12 am

  #316502

  I am trying to extract data through SSIS package from the cube using MDX query,when there is data it doesn't complain or error out but when it doesn't it returns below error . Is there a way to fake the metadata or return metadata with out any rows so that the package doesnt fail.

  Any other workarounds which i can use so that the package doesnt fail ?

  Error at Extract Cube: No column information was returned by SQL command

  Thanks in Advance

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman