A co-worker has left our company and now I am responsible for maintaining our SQL Server Integration Services (SSIS) code. I have a project that runs perfectly normal on my coworkers computer, but when I copy all the files to my computer, it errors out.
Specifically, the package creates a PDF report for a list of users, and then emails each report to each user. On my computer all of the PDF reports are coming back at 0 KB and when the package attempts to email the file, I get the following error:
Error: 0x1 at Script Task: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.IOException: The process cannot access the file 'C:\FC\adam.hargis.pdf' because it is being used by another process.
The way the package works, we have a script task that references some VB.NET code. This code calls a SQL Server Report. After all reports are created, we then look through the users and send them each their report.
Given that it works on one computer, and not another, I am thinking its some security or environmental issue and not code. Problem is I am relatively new to SSRS and not sure where to look. From what I can tell all the folder permissions are the same for the default "User" group on each computer as well as for the WindowsId I am using on each machine.
Any other thoughts are suggestions would be appreciated.