1. While exporting data in a flat file I am looking for an example to add column header, footer, number of records using ssis 2008.
2. Is it possible to see if file already exists and rename it before writing a new file?
3. Delete any files extracted older than 30 days
4. I also need to package and schedule for automatic execution . How one can do it thru ssis deployment?