Need help creating a custom SSIS script component
Posted on 2008-10-13
I need help creating a custom script component (Destination) which will handle a record update. This component would be used in place of the Ole DB Command, because the command object cannot deal with blob data (this includes text and ntext columns).
I'm using a conditional split to easily identify modified records, so all I need the object to do is to take all fields from the input, and copy them to the destination table.
I'm not concerned about the performance of this, because updates will only be in the 10's and not 100's or more.
Any help would be greatly appreciated!