Home Forums Data Warehousing Integration Services SSIS package has two separate Excel to SQL table imports, 2nd doesn't work RE: SSIS package has two separate Excel to SQL table imports, 2nd doesn't work

  • Have I checked to be sure no one else is in the Excel file? Actually I had Windows Explorer open to the very folder the TWO Excel files are in. They are the only files in that folder, and when one of those Excel files is opened by someone, anyone or anything, another file will also open that has two characters preceding the real file name. I assume this is a "locking" file. Those two characters are: "~$" When I am testing my SSIS package, I watch this folder to be sure no one else has either of these files open. I have found out the problem was a permissions problem. That has been fixed, but the package still does not work when executed from the Catalog on the Server. That question is in a new post.

    [font="Comic Sans MS"]Vic[/font]
    www.vicrauch.com