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
Solved

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

Posted on 2012-04-04
3
309 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
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

792 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