Hi
I have built a custom ssis task which reads a text file in and outputs it. I have a custom param which tells it the number of lines I want to read.
How do I implement this in the code sample below:
public override void ProcessInput(int inputID, PipelineBuffer buffer)
{
if (buffer.EndOfRowset == false)
{
try
{
//Get number of rows to read
int noOfRowsToRead = int.Parse(ComponentMetaData.CustomPropertyCollection["noOfRowsToRead"].Value.ToString());
for (int x = 0; x < noOfRowsToRead; x++)
{
//HELP HERE HOW WOULD I ADD ROWS TO DESTINATION BUFFER SO IT IS AVAILABLE
//TO A DOWNSTREAM COMPONENT.
}
}
Thanks
I have built a custom ssis task which reads a text file in and outputs it. I have a custom param which tells it the number of lines I want to read.
How do I implement this in the code sample below:
public override void ProcessInput(int inputID, PipelineBuffer buffer)
{
if (buffer.EndOfRowset == false)
{
try
{
//Get number of rows to read
int noOfRowsToRead = int.Parse(ComponentMetaData.CustomPropertyCollection["noOfRowsToRead"].Value.ToString());
for (int x = 0; x < noOfRowsToRead; x++)
{
//HELP HERE HOW WOULD I ADD ROWS TO DESTINATION BUFFER SO IT IS AVAILABLE
//TO A DOWNSTREAM COMPONENT.
}
}
Thanks