|
Home > Archive > MS SQL Server > December 2006 > Change values in SSIS.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Change values in SSIS.
|
|
| ChrisR 2006-12-12, 7:12 pm |
| 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
| |
| John Bell 2006-12-13, 5:18 am |
| 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
>
>
>
>
>
| |
| ChrisR 2006-12-13, 7:12 pm |
| Thanks.
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:5FAF7EA7-D0E7-41FB-AF37- B70DA73AE95E@microso
ft.com...[color=darkred]
> 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]
|
|
|
|
|