question

MarkMarkMarkMark avatar image
MarkMarkMarkMark asked

SSIS locking import file help

So... Here's the issue. I have a fairly simple excel file that I need to import. I need to import the file to two sql tables. The first table contains the file blob and attributes: filename, created date, updated date, owner, etc. The second table will hold the contents of the excel file. I've written a c# script task to extract the file attributes - fairly simple. Unfortunately, I get a error opening the file when I try to write to the blob - I think because SSIS locks the file during processing. Anyone have experience with a problem like this?
ssisexcelimportblob
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Alvin Ramard avatar image
Alvin Ramard answered
I've had errors with file locks before. I blamed it on Windows being too slow in releasing the locks. In one case, I added a script task to add a 2 second delay between steps and that resolved the issue.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.