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 access sum(Some_Column) in SQL

I am trying to build a new dataset based on existing set, by appending a
total value to the original one. (So I could pass this new dataset into a bar
chart to plot)
I know the sum(Some_column) is in the report domain, since we can access
this value in designer. But my question is how can I pick it out using SQL
statement to build another dataset. Or if there is better way to construct
the new dataset.
Micosoft gurus, please help. I am doing a consulting project at client side
for MS. Do not want to blow this one :)
--
SincerelyHave you tried using the ReportItems collection to reference the sum
field,and use it as a parameter into the other query?
ie
ReportItems!Textbox1.Value
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:7D89CBF3-D016-459F-B3F3-B1FC58DE3B3A@.microsoft.com...
> I am trying to build a new dataset based on existing set, by appending a
> total value to the original one. (So I could pass this new dataset into a
bar
> chart to plot)
> I know the sum(Some_column) is in the report domain, since we can access
> this value in designer. But my question is how can I pick it out using SQL
> statement to build another dataset. Or if there is better way to construct
> the new dataset.
> Micosoft gurus, please help. I am doing a consulting project at client
side
> for MS. Do not want to blow this one :)
> --
> Sincerely