Export to Excel

Question

Export to Excel

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Christo Wolmarans Ten Centuries Points: 1170 More actions · Answer 1

Hi

I'm relatively new to SSIS as well and I have to agree that DTS was a lot quicker and easier.

I would however suggest that you use the SSIS Import and Export Wizard to do this. It creates all the tasks for you and the steps are basically the same as the Import and Export Wizard in SQL 2000.

jerstep SSC-Addicted Points: 402 More actions · Answer 2

Brilliant. Thanks for that. The Import/Export wizard is exactly what I was looking for.

J

M Jones SSCommitted Points: 1711 More actions · Answer 3

I am having trouble with Excel exports as well. I want to be able to run the same export more than once without intervention and I want each run to clear the worksheet from the previous run(s). I used the Import/Export Wizard and it set everything up for me but when I test the package, I get the following error:

Error: 0xC002F210 at Clear Worksheet Task, Execute SQL Task: Executing the query "DELETE FROM `RepList`
" failed with the following error: "Deleting data in a linked table is not supported by this ISAM.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Clear Worksheet Task

I've tried adjusting the ResultSet property settings but no luck. Anyone know how to fix this to make it work for me?

Thanks!

mj

~mj