Solved

SSIS locking file in data flow task, not releasing when completed

Posted on 2012-04-04
3
315 Views
Last Modified: 2012-08-20
I have an excel file that is loaded in a data flow task and then is renamed to include the date and moved to an archive folder.  For some reason the data flow task is locking the file and preventing me from moving it even after the task has completed.  I have this process working under several packages for several other files and don't see any difference between them.  The Excel.exe process is not running and I can't find anything that would point me to what could be causing the issue.

Has anyone had a similar problem?  The closest thing I found was to move the file to the archive folder before processing, but this will not work as the file name changes to include the date.

Thanks
0
Comment
Question by:bcullenward
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 15

Expert Comment

by:Anuj
ID: 37809851
How are you renaming the file, is that using .Net?
0
 

Accepted Solution

by:
bcullenward earned 0 total points
ID: 37811108
It was renaming via a File.Move in the script task.  

The good thing is that it started working without me doing anything, the bad thing is I don't know the cause.

This can be closed.
0
 

Author Closing Comment

by:bcullenward
ID: 38310992
It fixed itself
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question