Post reply

Excel Source - validation error - due to file already open for edit by different user

  • January 11, 2013 at 2:25 pm

    #393923

    I have a SQL Agent job that run an SSIS package, which reads two different excel files. Sometimes, one of the files is open for edit when my job is run. The step fails to validate, as one of the files is not available to open.

    Is there a way, using ssis-excel-source, to open an excel file as readonly, just in case someone else has the file open for edit?

    Thanks very much,

    rcloud 🙂

  • January 11, 2013 at 2:28 pm

    #1576511

    i've always done a file task to copy an excel to a new file with a name unique to the process, so i was sure my process was the one and only process touching the file.

    that way i work around the issue of being open by other processes.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 11, 2013 at 3:03 pm

    #1576521

    Thanks. That will fix my issue.

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

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