/// <summary>
/// Determines whether the collection [contains] [the specified DTS Column value].
/// </summary>
/// <param name="value">The value.</param>
/// <returns>
/// <c>true</c> if [contains] [the specified value]; otherwise, <c>false</c>.
/// </returns>
public bool Contains(DTSColumn value)
{
return(List.Contains(value));
}
/// <summary>
/// Creates the column transformation object.
/// </summary>
/// <param name="sourceColumn">The source column.</param>
/// <param name="destinationColumn">The destination column.</param>
/// <param name="customTask">The custom task.</param>
/// <param name="fieldOrdinal">The field ordinal.</param>
private void createColumnTransformation(DTSColumn sourceColumn, DTSColumn destinationColumn,
ref DTS.DataPumpTask2 customTask, int fieldOrdinal)
{
try
{
DTS.Transformation2 oTransformation = (DTS.Transformation2)
customTask.Transformations.New("DTS.DataPumpTransformCopy.1");
// create new source and destination DTS.columns
oTransformation.SourceColumns.Add(oTransformation.SourceColumns.New(sourceColumn.Name, fieldOrdinal));
oTransformation.DestinationColumns.Add(oTransformation.DestinationColumns.New(destinationColumn.Name, fieldOrdinal));
oTransformation = null;
}
catch(Exception ex)
{
throw ex;
}
}
/// <summary>
/// Inserts a DTS Column at the specified index.
/// </summary>
/// <param name="index">The index.</param>
/// <param name="value">The value.</param>
public void Insert(int index, DTSColumn value)
{
List.Insert(index, value);
}
/// <summary>
/// Removes the specified DTS Column value.
/// </summary>
/// <param name="value">The value.</param>
public void Remove(DTSColumn value)
{
List.Remove(value);
}
/// <summary>
/// Adds the specified value.
/// </summary>
/// <param name="value">The value.</param>
/// <returns></returns>
public int Add(DTSColumn value)
{
return(List.Add(value));
}
/// <summary>
/// The Index of the DTS Column object.
/// </summary>
/// <param name="value">The value.</param>
/// <returns>Returns the index of the DTS Column</returns>
public int IndexOf(DTSColumn value)
{
return(List.IndexOf(value));
}
/// <summary>
/// Determines whether the collection [contains] [the specified DTS Column value].
/// </summary>
/// <param name="value">The value.</param>
/// <returns>
/// <c>true</c> if [contains] [the specified value]; otherwise, <c>false</c>.
/// </returns>
public bool Contains(DTSColumn value)
{
return (List.Contains(value));
}
/// <summary>
/// Removes the specified DTS Column value.
/// </summary>
/// <param name="value">The value.</param>
public void Remove(DTSColumn value)
{
List.Remove(value);
}
/// <summary>
/// Inserts a DTS Column at the specified index.
/// </summary>
/// <param name="index">The index.</param>
/// <param name="value">The value.</param>
public void Insert(int index, DTSColumn value)
{
List.Insert(index, value);
}
/// <summary>
/// The Index of the DTS Column object.
/// </summary>
/// <param name="value">The value.</param>
/// <returns>Returns the index of the DTS Column</returns>
public int IndexOf(DTSColumn value)
{
return (List.IndexOf(value));
}
/// <summary>
/// Adds the specified value.
/// </summary>
/// <param name="value">The value.</param>
/// <returns></returns>
public int Add(DTSColumn value)
{
return (List.Add(value));
}
