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?

more ▼

asked Dec 14, 2015 at 02:06 PM in Default

avatar image

0 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Dec 15, 2015 at 04:38 PM

avatar image

Alvin Ramard
1.4k 2 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 14, 2015 at 02:06 PM

Seen: 84 times

Last Updated: Dec 15, 2015 at 06:31 PM

Copyright 2018 Redgate Software. Privacy Policy