I am a binger in creating SSIS package programmatically.
I am able to write code to create package programmatically using Data Flow Task, FTP Task, SEND MAIL Task, script Task etc. In Data Flow Task I am able to add OLEDB Source, OLEDB Destination, Merge, Join component successfully.
But failed to add Script Component in data flow task.
Can any body suggest how to write script component programmatically under data flow task?
I am using SQL server Data tool which come with Microsoft SQL server 2012.