Hi Team,
Could anyone help out accessing the dataflow task properties thru' script component. I hv a SSIS pkg which transfers content from a txt file to database. I use FlatFileSource and SQLServerDestination objects in DataFlow Task. My prime requirement is to transfer some specific rows from the txt file to sql destination. We hv FirstRow and LastRow properties in SQLDestination object. But the problem lies in accessing the customer properties thru' code(script component
vb.net code). coz the incoming txt file wld be dynamic and I know the starting line based on some conditions. I hv assigned the start and end line values into a global variable thru script code. But finding it difficult to set the FirstRow and LastRow custome properties by reading this global variables. Appreciate anyone's kind effort to resolve this issue. many thx in advance
Regards,
Maruthi
maruthi