November 28, 2018 at 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
November 28, 2018 at 5:21 am
Chris-475469 - Wednesday, November 28, 2018 3:13 AMHi,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?
November 28, 2018 at 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.
November 28, 2018 at 1:51 pm
Chris-475469 - Wednesday, November 28, 2018 1:48 PMThe 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?
November 28, 2018 at 2:34 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy