Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Another User Has Locked My File!

I had an SSIS package fail in a script task this morning. As part of the why process I opened up one of the files it was processing and got this message:

 

image

 

I get the idea and I’ll hunt around to find what has it open, but I’m bemused at ‘another user’ which is either a really great domain user name or a fun default when no user name is available – presumably the latter. The package is using GetSchema to get the sheet names and I suspect it is/was the cause, but I wonder why no useful user name provided?

In the course of a quick search I found this post that doesn’t answer that question, but does go into a lot of detail (look at the flow chart!) on all the various ways it can happen.

Comments

Leave a comment on the original post [sqlandy.com, opens in a new window]

Loading comments...