Hi,
I am new to SSIS. I have been searching for some examples to
use Expression Builder in SSIS to use derived columns
transformation...I basically want to perform tasks like -
1. Add a new column to my flat file data source (also, next Excel
datasource) on the run (which simply contains a constant string ex:
"TXT") and add this column as the 2nd column before loading into
destination. (SQL Server DB table)
2. Rearrange my datasource columns according to my destination columns.
3. Not include some unwanted columns existing in the datasource while
loading into destination.

How can I achieve these? Plz help.

Is there a link where I can get examples online?? I went through the
SSIS tutorials (5 lessons) included with the product, it gives me a
fair idea now...but would really appreciate specific suggestions for my
requirements.

Thanks in advance!

Hello Vij,

1. use a derived column and simply type in the Value "Txt"
2. Why? This serves no purpose other than aesthetics
3. You can remove columns fro the pipeline in the Source Adpater AND/OR
you should use a query instead of a table object and only use the olumns
you need.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com