Hi All,

I'm using a Data pump task which transorms a CSV file to a Table (Source:CSV
file,Destination:Table) .There are some columns in the Table which don't
exist in the CSV file.I'd like to update those columns in transforming rows
..IS it possible?

Thanks

yes, just select the column from the table without a source that you want to
add data to and you can do your transformations within an ActiveX script

"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Simon,

Here is what I want to do:

Source: Column1
Destination: Colunm1,Column2

I'd like to check Column1(while it's being transfered) and if it's for
instance more than 5 ,I'd like to update Column2 (in the destination) and
skip processing the current row (using DTSTransformStat_skip).

Thanks


"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote

Yes, you can defietly do that within an activeX script task.
In the transformation section of the data pump task, select column1 on the
left side, and select column1 and column2 on the right hand side. Then
click new transformation and select type of ActiveX.

Then you can run case statements within to either update column2 only or
column1 only

example
Function Main()
Select Case DTSSource("Column1")
Case "First Check"
DTSDestination("Column1") = DTSSource("Column1")
Case "Second Check"
DTSDestination("Column2") = "The value you want to assign"
End Select
Main = DTSTransformStat_OK
End Function


"RayAll" <RayAll (AT) microsft (DOT) com> wrote

Simon,

I thin this is not gonna work to me ,because the column2 actually contains
the error code that might happen for checking each column.Let me tell you
the whole senario.

I have 33 columns in my CSV file ,In my destination Table there are 34
columns.
I am going to validate every single field (in each row) and if they don't
meet the validation (for instance if they are null where they are not
supposed to be null) ,I am going to update the 34th row with an error code
which I am getting from a lookup.so in every single field I should be able
to to have access to the 34th column.When the data pump task is done.I am
going to execute another package (or another pump task) to distribute all
rows (considering the error code in the 34th column) into 3 different
tables.

Hopefully I could transfer what I am doing now.If you have any suggessions
on the whole concept ,I would be really grateful to hear that.

Thanks
"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote