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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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