SSIS - create table caueses error in SSIS

Question

i would like to create table but it causes error about the connection, anyone know how to fix?

my connection setup as below

Answer 1

Hi @nononame2021 ,

I tested locally that there is no issue with code below.

CREATE TABLE `SSIS` (  
    `id` INT,  
    `name` NVARCHAR(50)  
)  

Make sure you have permission to read and write the excel file, also check if the file is read-only.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.