Saving SSRS report result as a pipe separated file

• SQLCurious

  SSCrazy

  Points: 2339

  More actions

  April 20, 2015 at 11:04 am

  #300091

  I have an SSRS report that is running in production environment, and everything is hunky-dory with it. Now I need to automate the result of this report to be delivered to a few select users every morning. The format of this report needs to be a flat file with "|" as the column delimiter. Is there anyway to achieve this without having to meddle with report server settings? Because once I change the settings, it may mess it up for other reports whose results the users may want to save as "CSV" files.

  Please advise.

  SQLCurious

  PS: xp_cmdshell is not allowed on this server (or the domain), so using bcp is ruled out for me.

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  April 21, 2015 at 2:48 am

  #1792311

  Hi

  Imho you can create SSIS package and set it as a job in SQL Agent.

  Br.

  Mike