Change values in SSIS.

Howdy all. In DTS there was a way too change the values of a column during
and export to another table using ActiveX Script:

Source:
Table1
column1
column2

Destination
Table2
column1 (I want this to contain the exact values from Table1.column1)
column2 (I want this to contain the values of Table1.column2 + 10)

Basically you would do this through the mappings, instead of a Copy Column,
you would use an AxtiveX script for that column. How can this be done in
SSIS?

TIA, ChrisR

Hi Chris

You can use a script component as a transform task see
http://www.sqlis.com/default.aspx?307,1

John

"ChrisR" wrote:

> Howdy all. In DTS there was a way too change the values of a column during
> and export to another table using ActiveX Script:
>
> Source:
> Table1
> column1
> column2
>
> Destination
> Table2
> column1 (I want this to contain the exact values from Table1.column1)
> column2 (I want this to contain the values of Table1.column2 + 10)
>
> Basically you would do this through the mappings, instead of a Copy Column
,
> you would use an AxtiveX script for that column. How can this be done in
> SSIS?
>
> TIA, ChrisR
>
>
>
>
>

Thanks.


"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:5FAF7EA7-D0E7-41FB-AF37- B70DA73AE95E@microso
ft.com...
> Hi Chris
>
> You can use a script component as a transform task see
> http://www.sqlis.com/default.aspx?307,1
>
> John
>
> "ChrisR" wrote:
> 
 during[color=darkred
] 
 Column,[color=darkre
d]