Hello, I'm trying to insert data from 2 similar sources with different tables (Means in OLE DB Source I write down a sql script). Both of the sources bring results, in the flow I see a successfully row counts from both of them until end of the flow. The strange thing is at the end table that has data from only one source and nothing from the other. I had checked it many times. No error or log returns any problem, and the process is run successfully. Also I was trying to delete the OLE DB connection, and create it again - not help. I need for any suggestion or advice please. Thank you, Gila

Hi Gila, 1) Need to check which transformations are being used in the data flow task. 2) If there are any conditional splits used, it is normal that there would be no records reaching one of the destinations.Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

Hi, Thank you for your replay. I just solve it by delete the destination component, save it, and return it. and it is works! Thank you any way. Gila