Apr
7
2009

Setting the DataType of IDTSParameterBinding objects (Execute SQL Task)

If you're writing Integration Services code that uses the Execute SQL task, you also have to create parameters programmatically. The ParameterBindings property of the ExecuteSQLTask returns an IDTSParameterBindings collection of IDTSParameterBinding objects, each of which has a DataType property. But the DataType is just an integer. Where do the values come from? Why doesn't it just get its values from an enumeration that's clearly documented? Well, the values for the DataType of an IDTSParameterBinding dep... [More]