SSIS Package to generate report and overwrite everytime is is executed

• divyasushil.tripathi

  Valued Member

  Points: 63

  More actions

  March 29, 2011 at 7:40 am

  #247924

  Hi,

  I created an SSIS package using import/export wizard, This package pulls a report and send it across email.However my package is not overwriting the data everytime its called; infact it gets appended to the same sheet, I want this data to be overwritten everytime.I dont get any such option in "destainationconnectionflatfile" in connection managers. I remember we get overwriting option while creating the package. Please advise how can I edit this package to overwrite the file.

  Thanks,

  Divya

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  March 29, 2011 at 7:49 am

  #1304864

  If you are creating a report through SSIS I would recommend creating the report through SSRS and then setup a subsrciption for the report.

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• divyasushil.tripathi

  Valued Member

  Points: 63

  More actions

  March 29, 2011 at 8:12 am

  #1304890

  Thanks Dan,

  I was able to get it overwrite in Conection manager for Destainationconnectionflatfile.

  Have a nice day!

  -Divya