Dts object not visible in my DataFlow ScriptComponent

I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible.

Dts.TaskResult =Dts.Results.Failure

The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow.

One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent'

I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange?

Any help appreciated.

Regards,

Paul.

Try these two links I think he covered what you need but your problem could be getting your data from DLL instead of a file which makes it simple. There are 40 articles on SSIS by the same writer so spend time with his tutorials. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3576126

http://www.databasejournal.com/features/mssql/article.php/3570991