putting data into excel using dts

• verkampa

  Newbie

  Points: 5

  More actions

  September 11, 2009 at 12:36 pm

  #138010

  I have a dts package that places data into a existing excel spreadsheet. The data is being placed at the last line of where the previous data was. For example, if the 1st time I ran the dts, it places 5 rows of data. I rename that file and send it off. Then I delete all the rows of data in the original spreadsheet; however, the next time I run the dts, the data will start being populated in row 6. How do I get the data to start populating in row 2, right after the headers?

  When it populates this spreadsheet, I want the data to remove the previous data and place the new data in the spreadsheet.

  Thank you

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 11, 2009 at 12:55 pm

  #1052513

  The problem lies within Excel as acknowledge by Microsoft. Read this

  Article ID: 244435 - Last Review: February 19, 2008 - Revision: 6.1

  How to reset the last cell in Excel

  This article was previously published under Q244435

  http://support.microsoft.com/kb/244435

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]