Error At OutputColumn.SetDataTypeProperties(dataType, Length, Precision, Scale, TargetColumn.CodePage);

I have generated the package ! but it gives me an error at:


outputColumn.SetDataTypeProperties(dataType, length, precision, scale, targetColumn.CodePage);

private void ConfigureDataConversionComponent(Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSComponentMetaData90 dataconversionComponent)

{

PipeLineWrapper.CManagedComponentWrapper managedOleInstance = managedOleInstanceDataConversionComponent;

// Get the derived's default input and virtual input.

PipeLineWrapper.IDTSInput90 input = dataconversionComponent.InputCollection[0];

PipeLineWrapper.IDTSVirtualInput90 vInput = input.GetVirtualInput();

// Iterate through the virtual input column collection.

foreach (PipeLineWrapper.IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)

{

managedOleInstance.SetUsageType(

input.ID, vInput, vColumn.LineageID, PipeLineWrapper.DTSUsageType.UT_READONLY);

}

// putting the truncation row disposition

dataconversionComponent.OutputCollection[0].TruncationRowDisposition =

PipeLineWrapper.DTSRowDisposition.RD_NotUsed;

// putting the error row disposition

dataconversionComponent.OutputCollection[0].ErrorRowDisposition =

PipeLineWrapper.DTSRowDisposition.RD_NotUsed;

// get the output column collection reference

PipeLineWrapper.IDTSOutput90 output = dataconversionComponent.OutputCollection[0];

foreach (PipeLineWrapper.IDTSInputColumn90 inColumn in

dataconversionComponent.InputCollection[0].InputColumnCollection)

{ // create the map

// get the target column from the mapping informations

PipeLineWrapper.IDTSOutputColumn90 outputColumn =

dataconversionComponent.OutputCollection[0].OutputColumnCollection.New();

outputColumn.Name = inColumn.Name;

Column targetColumn = GetTargetColumnInfo(inColumn.Name);

// find out the length of the column

int length = targetColumn.Length;

// get the precision of the target column

int precision = targetColumn.Precision;

// get the scale of the target column

int scale = targetColumn.Scale;

// get the SSSIS complaint datatype from the given mappings

Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType dataType = targetColumn.DataType;

// setting the data properties

outputColumn.SetDataTypeProperties(dataType, length, precision, scale, targetColumn.CodePage);



// putting the external metadata column id to zero

outputColumn.ExternalMetadataColumnID = 0;

outputColumn.ErrorRowDisposition = PipeLineWrapper.DTSRowDisposition.RD_RedirectRow;

outputColumn.TruncationRowDisposition = PipeLineWrapper.DTSRowDisposition.RD_RedirectRow;

PipeLineWrapper.IDTSCustomProperty90 property = outputColumn.CustomPropertyCollection.New();

property.Name = "SourceInputColumnLineageID";

property.Value = GetSourceColumnLineageID(targetColumn.Name);

property = outputColumn.CustomPropertyCollection.New();

property.Name = "FastParse";

property.Value = false;

// Now we are preserving the Lineage id into a list.

// you know, when later we will configure the dataflowcomponent of SQL destination

// then, we will find all the inputs (the input came from flat file and the inputs

// came from the derived columns output). And we need to distinguish among them.

// we will only consider those inputs into the data destination component, where the

// inputs are came from the out put of derived column component. which is actually here.

derivedLineageIdentifiers[outputColumn.LineageID] = outputColumn.Name;

}

}