Viewing 15 posts - 5,836 through 5,850 (of 13,877 total)
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 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
I'm using Visual Studio 2012 and also new to SSIS.
I have a simple package with a...
March 9, 2017 at 7:34 am
ravi@sql - Thursday, March 9, 2017 6:02 AMHi Champs,Please suggest how to import fixed width flat file to DB using ssis 2012 ?
Regards,
Ravindra
How...
March 9, 2017 at 7:19 am
I use data flows just not in this instance, it was created before I arrived Phil....
March 8, 2017 at 12:18 pm
lkennedy76 - Wednesday, March 8, 2017 10:59 AMI am putting several SP's in a sequence container with begin and commit transaction and failure emails.
That's...
March 8, 2017 at 11:22 am
all my components are in the Control Flow. Once...
March 8, 2017 at 10:15 am
Viewing 15 posts - 5,836 through 5,850 (of 13,877 total)