First I want to apologize for my bad English and I hope "the most"
forum members will be able to understand my question.I'm a beginner, so don't get a blow on the head after this question.
I want to migrate data from table1 to table2. The structure of these tables are the same. In the migration process I have to add a new column to table2 (for insatnce columnX) and to migrate into this column the values from a column from table1 multiplied by 100.
I hope anybody can help me to solve this problem.
TIA
Regards smilebey
Why not use T-SQL rather than SSIS, if the tables are in the same DB or sever even it would be simpler and easier.
If you use SSIS, then look at the Derived column Transformation, and use a simple expression such as -
[columnx] * 100
|||Thank you.The reason why I am using SSIS is that I am migrating data to MS CRM database. And I won't (and cannot) migrate one column to the destination database and the other columns with SSIS. I think it is more smart to do the migration with one procedure and one tool.
Best regards
smilebey
No comments:
Post a Comment