Hi all, I've migrated package from 2005 to 2008R2. This package has ADO.net source and SQL destination. When i did preview in ADO.new source i can see data but in sql DESTINATION I CAN SEE nulls (....) . Also When i run the package everything looks fine DFT is green also The flow is showing 5000 records are transferred. My staging table has 5000 records but all of them are null. When i run the package through 2005 all the data loaded. Please anyone let me know is there any properties that i need to set for ADO.net source when i migrated the package. Thanks, Jyo

Hi Jyo, What is showing up in the DataViewer? Double-click on the connector leading to the destination and set it up.Show here what you see. I think you need to check the mapping.Arthur My Blog

Data Viewer is showing all NULLS

Then there's something wrong with your source. There are no "configuration" type things you have to alter on an upgrade - but is it possible that something in your environment has also changed due to your upgrade? Probably. Can you confirm that a Data Viewer immediately following the Source component shows all NULLs in the data flow? (Need to make sure the source is actually the problem.) Please describe how your ADO.Net source is configured. Talk to me now on

Yes Data viewer is very next to ADO.net source. Also Here are the properties :

Also I noticed that only text data is not flowing but Numeric data is flowing

But it is a Data Reader destination, then you have set to be consumed elsewhere, right? Noticed the SELECT * --> this is a bad practice everywhere. I suspect this data reader needs a metadata refresh.Arthur My Blog