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...
-
SQL Server Data Masking : Download code DataMasking.sql Masking data can be done through updating the confidential information in t...
-
Pivot without Aggregating with consistent and inconsistent formats: One of the most common tasks which I came across at least once in almo...
No comments:
Post a Comment