Adding SCRIPT and LOOK UP components using C#

Hi,

Could you please tell me how to add SCRIPT and LOOK UP component to a data flow using C#? Also, is there any artilces/site which gives information about the SSIS programming?

Regards,

Gopi

Gopinath M wrote:

Also, is there any artilces/site which gives information about the SSIS programming?

from the bol: http://msdn2.microsoft.com/en-us/library/ms136025(sql.90).aspx

|||

Douglas,

The bol link gives information about the basic components and tasks. I'm looking for more information related to the components like LOOK UP transerformation, SCRIPT componenet, Conditional Branching component. Could you please let me if you know where we get reference material ?

Regards,

Gopi

|||

Adding components programatically is pretty much the same for any component - you just need to be aware of specific properties for each, and they are described in BOL.

The exception is the script component which relies on the VSA project infrastructure - we are looking to improve this capability in the future. Having said that, if you can programatically create a package, you certainly have the skills needed to write a custom component rather than using a script component - custom components are more flexible and easier to reuse, especially programatically.

Donald