-1

I am new to ssis. I want to schedule a job to create a csv file daily. So each day, the existing file should be deleted and I want to create a new csv file. Could you please help me with this?

Mihail Duchev
  • 4,691
  • 10
  • 25
  • 32
Sharon
  • 3
  • 1
  • You can try using a `FileSystem task`, but I don't know how it handles exceptions (e.g. file doesn't exist on first call). However, I usually create a small Scripttask (C#) where I check if the file exists and perform the deletion basing on the result of this check. – Tyron78 Nov 12 '20 at 09:49

1 Answers1

0

As for deleting existing file, the flat file connection properties should have a tick box to overwrite the existing file. If the file is not locked by another process like Excel that should be sufficient to ensure the old one is replace by the new one

If you need more guidance on how to build the package you can have a look at the below link

Exporting to CSV

Ockert
  • 425
  • 4
  • 6