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