Post reply

Fetching Row Count In SSIS

  • April 11, 2008 at 6:23 am

    #121394

    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

    #801497

    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

    #801518

    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

    #801574

    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

    #801612

    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