Viewing 15 posts - 5,836 through 5,850 (of 13,879 total)
March 10, 2017 at 9:04 am
You are not looking at the correct window. The values in the Variables window do not change.
There is another window, called locals or local variables (I'm not in...
March 10, 2017 at 7:08 am
There is always only one record in the ReportingPeriod table. I removed the Parameter Mappings and...
March 10, 2017 at 6:48 am
If you don't tell us what you are expecting, how do you expect us to help?
March 10, 2017 at 6:31 am
So your SQL Statement now says this?
SELECT Top (1) CurrentReportMonth, CurrentReportYear from CVUReportingPeriod
? I added in the Top (1) as a safety measure. Any more than...
March 10, 2017 at 6:28 am
I tend to do this differently from John. Let's say I have a select statement that returns two results in one row.
Create the variables.
Create the ExecSQL task.
Important points:
Set...
March 10, 2017 at 5:53 am
It appears the var_period and var_fy variables are never set in the first Execute SQL...
March 9, 2017 at 6:02 pm
the logic is...
March 9, 2017 at 5:58 pm
I'm struggling with getting this to work
1. Created two variables named var_fy and...
March 9, 2017 at 1:39 pm
March 9, 2017 at 1:16 pm
March 9, 2017 at 12:53 pm
March 9, 2017 at 9:57 am
Your code works fine as an iTVF:
DROP FUNCTION IF EXISTS dbo.FancyDateDiff;
go
CREATE FUNCTION dbo.FancyDateDiff
( @FirstDate datetime, @SecondDate datetime)
RETURNS TABLE
RETURN...
March 9, 2017 at 9:55 am
sgmunson - Thursday, March 9, 2017 9:21 AMJust curious as to why a DATEDIFF(year, FirstDate, SecondDate) doesn't work for you?
If you run the...
March 9, 2017 at 9:41 am
Does it work if you run it as a pure C# application?
Might help to work out whether this is an SSIS problem, or not.
March 9, 2017 at 8:35 am
Viewing 15 posts - 5,836 through 5,850 (of 13,879 total)