Add new Column

Hallo,
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

add Date and Time In Non english format(Farsi or arabic)

Please Help me
I want Store date and time in sql server tables but in non english format.
For example Arabic or farsi
How can i Do?
Help meeeeeeeee
ThanksI am not sure which format you want - but there are 2 Kuwaiti formats:

Style Format
130 dd mon yyyy hh:mi:ss:mmmAM
131 dd/mon/yy hh:mi:ss:mmmAM

You can alter your datetime data using the convert function. Look at convert in bol.|||Date and time are not stored in any "format" in the database. They are stored as numeric values indicating the days elapsed since a fixed point in time. What you are looking for is a way to display the datetime value in a particular format. You can use the convert function given by rnealejr when outputing your results, but generally issues of data-formatting and display should be handled by your user interface or reporting tool.

blindman