January 31, 2008 at 6:10 am
I need to export data to Excel using SSIS. This package would run daily. The issue I have is being able to overwrite the data inside the Excel file daily. The server is Windows 2003/SQL 2005/OpenOffice.
Any suggestions you have are greatly appreciated.
Thank you.
January 31, 2008 at 7:16 am
What have you tried so far? The data flow task and excel destination will do it for you.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
January 31, 2008 at 6:20 pm
I have tried putting an empty Excel file in the destination path. I have tried letting it create the file and either way I end up with a Connection failed issue or invalid format. I don't know if the server having OpenOffice on it is a factor or not.
Images attached:
I start with the Control Flow which is the SQL DB and Excel Connection Manager. The Data Flow has the source SQL database with a query which connects to the Excel destination file. I can use the same SQL database and query and send it to a text file without issue.
At this point I am just lost.
Thanks for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply