Hi ALL, I am using Microsoft SQL Server Management Studio 2008 R2 to do the ETL stuff. Source tables come from Oracle 11g. the target is Sql Server 2008. It's odd that when i set a data view at the last step of the data flow, the records output seems correct. but when i see the output table in SQL Server, except surrogate id and natural ID, other columns's value are NULL. Could you guys give me some clue about it. I have use Data convertation transformation, Derived column transformation in my data flow. Thanks~~

You might want to verify the column mapping of the OLEDB Destination in the Data Flow Task if the columns are being ignored or not.

do you got any error or warning? if yes paste exact message here. also is source and destination compatible in data types?http://www.rad.pasfu.com

Hi nplus, Sorry to reply late, how how can i fnd whether the columns are being ignored or not, i use SQL server destination transformation.

Hi Reza, There is just one kind of warning"[SSIS.Pipeline] Warning: "The output column "XXX" (3334) on output "XXX" (3028) and component "XXX" (3026) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. " I set the data view at the last step and see data are correct.I just wonder whether it is because the datatype, But sometimes the surrogate id column generate by "Row Number Transformation" is NULL as well, this column is generated by SQL Server and i think the data type should be match with SQL Server, but some table's surrogate id are NULL , some's are correct.

Pengqui, could you please list all of the objects in the data flow layer? It sounds like your problem is what nplus suggested. If you open the 'destination' object you should see a 'mapping' option. When you go into that you can see which columns from your data transform are being mapped to which columns in your table. If that's the problem, just add in the missing mappings and you're good to go.

nplus, I check the Destination transformation in the data flow , I found i have changed the name of the column leading to that sqlserver ignore these column. Thanks for your informaiton.