?
Solved

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

Posted on 2012-04-04
3
Medium Priority
?
323 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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