Unable to create simple table in SSIS Excel destination

Question

Hi All

i tried to create simple table .CREATE TABLE `Excel Destination` (
    `OMS_ORDER_ID` Integer ) , but i am facing the issue . what is the reason for that .
The table cannot be created. (Microsoft Visual Studio)

===================================

Unexpected error from external database driver (1309). (Microsoft Office Access Database Engine)

---

Surendra Thota

Answer 1

Hi Surendra

It appears to be an issue with the Excel file being currently used by another process/user (or just renaming orphaned in memory). 

---

Arthur My Blog

Answer 2

Hi Surendra

It appears to be an issue with the Excel file being currently used by another process/user (or just renaming orphaned in memory). 

---

Arthur My Blog

Hi ArthurZ

YES, that's it. You saved me after a good 2 days of trial-and-error and research, THANKS INDEED.