How to append a new values like uniqueidentifiers, sequence numbers to data flow?

Hi,

I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us ?

Append what to where? Do you want to add new columns with such vaues to a path within the data flow task?

Derived Column Transform?

Script Transform?

Row Number Transform ? (http://www.sqlis.com/default.aspx?77)

|||

yes..i want to append values to a path with in the data flow task.

If i use Derived Column Transformation, how can i generate uniqueidentifiers and sequence numbers for each row?

Thanks

Gopi

|||

For GUIDs you would need to use the script task, as there is no "New Guid" function in the expression syntax.

For sequence numbers or row numbers I assume, then again the script task is required. For an easier life you can use the cunningly named Row Number Transform I mentioned previously, which does just that, and comes as a simple MSI to install.

|||

Darren,

Thank you very much.

sql

How to add row number in cryatl report 10?

Hi all,
I am working in crystal report 10. In the report i need to add row numbers in each page starting from 1.
Eg: Page1 row1
row 2
row 3 ..
Page 2 row 1
row 2
row 3 etc..

Colud anyone pls suggest how this can be done? very urgent...

Regards,
AmbiliPut a formula in the page header to reset a row number variable, and one in the detail to increment / display it.|||Always remember

You initialize a vairiable in the Header Section, Increment it in the Details section, Show/Print it in the Footer section

regards
Amarjit

How to add all the values in a single column in a table?

numbers
2
4
2
Above is an example of my table with a single column. My problem is how to add all the numbers in that column to make it 8? The rows are also dynamic.
Your help is highly appreciated.

Is this what you are looking for:

SELECT SUM(numbers) AS total

Does this help?

|||select sum(numbers) from table
|||

You need to use a SUM function

select sum(numbers) from yourTable

Nick

|||Thats exactly really how i want it to be...! Thanks for the great help everyone....I really appreciate it...!