Fetching Row Count In SSIS

  • 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

  • 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?.

  • 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.

  • Sounds like a complicated way to avoid using an identity column. Why aren't you using an identity column?

  • 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