The process cannot access the file because it is being used by another process
You may face the above error when you are accessing a file in a script component in SSIS and trying to change the properties of the file in another transformation with out closing the file in the prior script component.
Example :
Dim myFS As System.IO.FileStream
....
....
myFS.Close()
Subscribe to:
Post Comments (Atom)
Featured Post
SQL Server AWS Migration BCP
stored procedure to generate BCP scritps to migrate the SQL Server database. Developed this stored procedure on my labs to simulate t...
-
query execution in the production taking long time one of the query in the production taking almost 40 minutes instead seconds where it us...
-
Pivot without Aggregating with consistent and inconsistent formats: One of the most common tasks which I came across at least once in almo...
-
Last updated: 10/5/2010 9:19 PM category topic links Database design interview question most common approaches to d...
No comments:
Post a Comment