Post reply

Issue with stored procedure as data flow source

  • November 28, 2018 at 3:13 am

    #373169

    Hi,

    I'm experiencing a strange issue when executing a stored proc within an ole db source component. My proc returns rows based on a date variable, and if I explicitly set this value at the beginning of my proc the data flow processes the correct amount of rows.

    The problem comes when I try to dynamically set the value of the date variable at the start of my proc using a SELECT statement. When doing this it doesn't return the expected amount of rows.

    Has anybody else experienced this?

    Thanks in advance

  • November 28, 2018 at 5:21 am

    #2014774

    Chris-475469 - Wednesday, November 28, 2018 3:13 AM

    Hi,I'm experiencing a strange issue when executing a stored proc within an ole db source component. My proc returns rows based on a date variable, and if I explicitly set this value at the beginning of my proc the data flow processes the correct amount of rows.The problem comes when I try to dynamically set the value of the date variable at the start of my proc using a SELECT statement. When doing this it doesn't return the expected amount of rows.Has anybody else experienced this?Thanks in advance

    Presumably you've tested this outside of SSIS, to ensure that the 'correct' number of rows are returned?

    How are you counting the number of rows which the proc returns, when running inside of SSIS?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • November 28, 2018 at 1:48 pm

    #2014874

    The proc works as expected when used outside ssis. When I call the proc in my package I'm capturing the row count and storing that in a table so I can see how many rows are processed.

  • November 28, 2018 at 1:51 pm

    #2014876

    Chris-475469 - Wednesday, November 28, 2018 1:48 PM

    The proc works as expected when used outside ssis. When I call the proc in my package I'm capturing the row count and storing that in a table so I can see how many rows are processed.

    Is the row count in SSIS always less than expected? 
    Is it always the same number?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • November 28, 2018 at 2:34 pm

    #2014886

    No the number is inconsistent but is always less.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply