Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

write row count value to one source

Status
Not open for further replies.

tirf

Programmer
Sep 22, 2008
59
US
I have 32 data flow tasks which are running same time; I want to get rowcount for each data flow and update it to a table.

my problem is I have to define 32 variables to write the rowcount on whcih I am not happy with; Is there a better way to define one variable and get all the counts without overwritting one another?

Thanks
 
No, if they are running at the same time you'll need a separate variable for each.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top