December 27, 2024 at 7:55 pm
Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone has it open? in my mind analogous to a dirty read in sql? maybe read what it had at last save? i'd hate to have an error handler alerting the file owner for hours that someone needs to get out of the file.
December 28, 2024 at 12:01 am
Not that I know of. However, I suggest that you add some steps to your process which help handle the issue.
Step 1: copy the file from source to a path not accessible by users
Step 2: continue the import from there.
I think Step 1 would allow you to grab the latest saved version of the file (not tested).
December 30, 2024 at 3:11 pm
thx Phil that's a great idea. i'll circle back here once i've stood up a poc.
December 30, 2024 at 8:32 pm
i posted a how to question for this at https://www.sqlservercentral.com/forums/topic/dont-see-a-file-system-task-approach-to-copying-excel . i was hoping to avoid copying content by using the file system task.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply