hey

Also been struggling for days with this issue.

A simple task that used to be easily dealt with in SQL200 DTS - just overwrite or create a brand new destination spreadsheet each time a package runs - simple.

I used to be able to create a packahge to export data to excel in 5 minutes with DTS.

Now it takes days and i have to define the detail of dozens more objects.

This is nonsense.

Simple tasks being made overly complicated doesnt help anyone.

Creating excel templates, deleting sheets before your package starts, connections having to be named, connection managers needing to be redfeined for every opackage that uses them.

Errors about excel sheets of a certain name already exisiting causing packages to fail - i dont care just overwrite the excel file if it exists.

Not impressed 🙁

I thought these tools were supposed to make a DBA's life easier not harder.