SSIS exporting to Excel problem

Discussion in 'microsoft.public.sqlserver.dts' started by Walter, Aug 6, 2010.

  1. Walter

    Walter Guest

    I'm using SSIS 2005 to export data to Excel. I'm getting a lot of instances
    in which SSIS is complaining that the file is open by another process or is a
    read only file when trying to create the excel file, load the file, or
    perform an NTFS operation such as delete or move. I have the readonly=0 in
    my Excel connection string and have even put steps ahead of the problem steps
    that execute a Waitfor to give SSIS the time to release the hold on the Excel
    file when moving from one step to another.

    The Excel file typically is being created on a file server and the SSIS
    package runs on the DB server.

    My typical steps in the SSIS package are create the Excel file, populate the
    file, email the file using a Script, then move or delete the file.

    Below are some of the error messages I get:

    "Cannot modify the design of table 'Excel Destination'. It is in a
    read-only database.". Possible failure reasons: Problems with the query,
    "ResultSet" property not set correctly, parameters not set correctly, or
    connection not established correctly."

    "Operation must use an updateable query."

    This is a sporadic problem. I can run the job via dtexec and it fails with
    an error above. Then I can run it again and it works fine. Same thing in
    BIDS.

    Any help would be appreciated! Thanks!

     
    Walter, Aug 6, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.