.Net and SSIS

Hi,
Is there way I could pass on an object to an IS package from a .Net component? Basically I need to validate a file using c# and pass the valid records to an IS packet to be uploaded to the database. Is this possible without me writing the valid records to a file and using that as input for the IS packet?

I tried doing the validation on the IS side as well but seems extremly slow so going to try to get a c# program to do that for me.

Appreciate your help....If you want to reuse this code - write a custom data source component for data flow. If this is to be used once only - use a script component to create the source.|||Siv1 - if you're looking to programatically manipulate a SSIS package from c# code, check out the Microsoft.SqlServer.Dts.Runtime namespace. You'll need to import a reference to Microsoft.SQLServer.ManagedDTS.dll. You can load packages into .Net objects and manipulate from there (even run the package).|||

If you want to use the output of an existing .NET assembly within a package, then perhaps you'll prefer to approach things from the other end than Jeff suggested, and invoke your existing assembly from within a Script task or Script component (with the inconveniences around reusability that Michael mentioned).

However you can also do things the other way around, and run your package from a .NET application, and if the package terminates in a DataReader destination, load that DataReader output into your client app, as described in BOL.

-Doug

|||Thanks guys for giving me an idea on where to start...