Sharon
Reputation: 3
How to delete an existing csv file and create new one in ssis?
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?
Upvotes: -1
Views: 815
Answers (1)
Ockert
Reputation: 443
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
Upvotes: 0
Related Questions
- How to remove a header row from a csv file using SSIS and SQL Server 2005
- Easy way of overwriting old rows in SSIS Package
- How to delete old csv file from multiple folder in ssis
- How do I delete excel rows in SSIS?
- Deleting the contents of a text file before importing in SSIS
- Overwriting excel file data in SSIS
- Update table from csv file
- SSIS - Delete rows
- How to delete data from excel sheet while creating and dropping table through SSIS package
- Modify Csv File by delete Rubbish Data and Storing the Data which need