Use EOD programatically

Mar 14, 2011 at 6:41 PM

Hi Rémy!

Before going into the problem I'm having, I just wanted to know if it was possible using your component to programatically update its inputs/ouputs?

What I'm trying to do is open an existing package programmatically (a package containing your EOD), update the data source's metadata (a SQL table name) and propagate changes through all the data flow task's component (including the EOD).

Thank you for your help!



Mar 14, 2011 at 8:04 PM

Honnestly I have never tried, but I think it's possible since i implemented all interface... 

Mar 14, 2011 at 8:18 PM

Thank you for the quick answer!

Here's what I encounter.  After updating a Source component's metadata from a new table programatically, I call ReInitializeMetaData on the EOD component and get the following error message from the Managed Debugging Assistant:

RaceOnRCWCleanup a été détecté
Message: Tentative de libération d'un RCW en cours d'utilisation. Le RCW est utilisé sur le thread actif ou sur un autre thread. Une tentative de libération d'un RCW en cours d'utilisation peut entraîner des dysfonctionnements ou des pertes de données.

This problem is only occuring when I run my code in a Console application.  Indeed, it runs perfectly without errors if I incorporate this code into a custom task and run it as a package.

Please let me know if you're aware of this problem!

Thanks again!



Mar 14, 2011 at 9:57 PM

I am really sorry, but since I change job I don't have SQL Server anymore. So I think I can't help you.