Cannot update. Database or object is read only SSIS

Question

Hi ,

I have an SSIS Package which loads the data from Excel file into OLE DB Destination(SQL Server).If I run the package regularly by just selecting the file as a source and it runs fine however my requirement is to grab a latest file everyday and load it.

I create a script task which runs fine and gets the latest file out of it, I have 2 variables to store the folder name & file name in it and when I try to change the excel source connection to run dynamically from the variables I get the following error:

"Cannot update. Database or object is read only"

I am not sure why this error occurs, I have a similar package which runs from picking up a file from the same location and load into the same server which runs fine however its just this one that fails.

I tried changing the Excel connection string to add : IMEX=1 which throws another error saying "Could not find installable ISAM"

Can someone please let me know if there is something I am missing here which is causing this issue?

Thanks

Answer 1

I just changed the Delay Validation = True for the package and it ran fine, I guess the issue it was trying to validate everytime and failing so once I changed it it started running fine.

Answer 2

Hi @sujith kumar matharasi ,

Please set ReadOnly=0 in the Excel Connection String.

Hope the following links will be helpful:
1.Specify ReadOnly using Microsoft Excel ODBC Driver
2.Working with Excel Files with the Script Task

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

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.