Clear the old data in flatfile before exporting new data

• srinu.bts

  Newbie

  Points: 1

  More actions

  March 11, 2010 at 3:27 am

  #386478

  Hi,

  Currently I am working on DTS packages in sqlserver 2000.

  My Question:

  According to my project user upload the excel file on webpage that the upload data srored into corresponding table in sqlserver after that , when run the DTS package that the uploaded data getting extracted from table and load into the flatfile(i.e exported from table to flatfile.)

  -->Again user had upload second time under the same area(in my project we have several tabs)for example upload had done with 10 records ,and again upload data stored into the corresponding table in sqlserver after that When I run the DTS packages ,that the latest uploaded data had appended to the flat file (getting extracted from table and load into the flatfile i.e exported from table to flatfile.)

  Now flatfile having previous data and currenta it was clubbed.

  Now my requirement is only current data is required in the flatfile,I dont want previous data ,So that i want to delete the previous data before exporting new data .

  Please help me on this.

  Regards

  Sreenivas

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  March 11, 2010 at 4:55 am

  #1131935

  Delete the old file and create again every time u run the dts. I am sure that u can do in DTS