April 11, 2008 at 6:23 am
I am fetching data from xls file. Based on the number of rows fetched from the file I need to perform certain operation on each row of the data.
Please suggest how to get the row count for the data fetched from the file.
-SM
April 11, 2008 at 8:06 am
You can use row count component, to store row counts in a variable.
what is the operation you are trying to perform after you get row counts?.
April 11, 2008 at 8:25 am
I am fetching customer information from a xls file. The customer Id is the unique number and I store the last number used in a different table. I have procedure which return the Last used ID+ Count (the number of Id's requested from the procedure). I assign these ids in customer row and then store it in my customer table.
I have tried to use the variable in script, but I think it do not allowed to use it outside the PostExecute.
April 11, 2008 at 9:17 am
Sounds like a complicated way to avoid using an identity column. Why aren't you using an identity column?
April 11, 2008 at 10:11 am
customer table is there on multiple databases but some how need to keep unique ID throughout.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply