below is the description of SSIS package,
Step 1 : Creating one excel file in step one using Script task
Step 2 : Uploading data to this newly created Excel file using Dataflow task.
Step 3 : Mailing the Excel file to user
Now the first 2 steps completes successfully but at step 3 it fails with following error:
[Send Mail Task] Error: Either the file "FileName" does not exist or you do not have permissions to access the file.
I think the file is locked with step2 how can i remove the lock?
Thanks in advance!!!
View Complete Post