Data type changes

If I have a derived column in the middle of a data flow diagram and I change the derived column's data type, I have to open all of the data flow items beyond it before the change is propagated. In one case I had to remove it from a merge join and re add it before the change was acknowledged.

Is there a faster, better way?
Thanks
Jim

[346 byte] By [JimArgeropoulos] at [2008-2-16]
# 1

Jim,

This propagation of data types have to be your conscious decision. We do not want to break anything downstream by doing this.

Thanks,

BobBojanic at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server

Site Classified