Just set up SSIS and MS 2012, getting permissions error and don't know where to proceed?

I just started using SSIS and am trying to upload an Excel file. When I get to the Excel Connection Manager and use the variable pointing to the file path of it's location, I get the following error:

"An OLE DB record is available. Source: "Microsoft JET Database Engine" HRresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file". IT is already opened exclusively by another user, or you need permission to view its data."

The SQL Server and SSIS software are brand new. The destination table is already set up. What could I try to fix the issue?

Answers


Looks like there is a lock on the file (on the server, right-click my computer, manager, system tools, shared folders, open files).

OR look for Excel Version in Excel connection manager, choose MS excel 97-2003. I assume you are using new version


Make sure you don't have the spreadsheet open in Excel, it will put a lock on the file and prevent it from being opened by SSIS.


sometimes if excel didn't close properly it might leave an instance in memory locking your file. You may need to check it with Task Manager and kill the excel instances manually.


Need Your Help

Windows 8.1 App Certification fails for Platform appropriate files

dll windows-store-apps app-certification-kit processor-architecture appxmanifest

My Windows Store App works for all architectures (x86, x64, arm) and is published on the Store. But when building App Package (right-click on project, Store, Create App Package) Windows App Certifi...

Question Marks Instead of Chinese Characters

php character-encoding cjk

I'm trying to place some Chinese text on a website, but as soon as the page is placed online, instead of Chinese text, i see a row of question marks ?????????? ???????????