Multicast to two different Flat File Destinations results in Error

Question

So I have a need to output the results of a SQL Server Stored Procedure to two different Flat File Destinations and we are using a Multicast in order to try and do so. When we run the SSIS Package, we get...

"The process cannot access the file because it is being used by another process"

I thought this was the whole idea behind the Multicast

Both files are writing out to our Network Shared Drives.

I'm just really confused by this error.

Am I missing something here??? Am I going to have to repeat my Data Flow task in order to work around this?? Seems like double the work for what I thought the Multicast was supposed to be used for.

When I copied the project and tried each file separately, it worked just fine.

Answer 1

Stupid Me! I copied the Flat File Destination but forgot to change the Connection Manager on it. Shame on me!

Thanks.

Answer 2

I created a simple SSIS package using a Multicast task to export a table data to two different names of the text files and it worked. Not sure if your package has some specific tasks in it.