
Here i have Crates one SSIS Package for data transfer form one server to another.
-->First i have created DataFlowTask and in that DataFlow i have Created OLEDB Source->DerivedColumns->OLEDB Destination.
Like below.
After that in OLEDB Source i have Assign my First server Database table.
After in Derived Columns i have Mapped Columns Here.
After in OLEDB Destination i have Set my another Server Database Table to insert data here in this table.
after running this DataFlowTask getting no Error. i have Checked in Progress for Getting rows.
after that i have checked in my Destination table for Rows.
there i didn't get any rows.
My DataFlowtask is running Perfact.
Can any one help me out where i m missing.
Thanks
*This post is locked for comments
I have the same question (0)I believe it is not related to AX. It would be better if you post this question in SSIS related forum.