Viewing 15 posts - 5,836 through 5,850 (of 13,874 total)
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
March 8, 2017 at 6:28 am
Do you intend to do this in a data flow, or did you mean script task?
March 8, 2017 at 5:02 am
I already have a...
March 7, 2017 at 1:01 pm
I have a nightly import job that imports from a MySQL linked server into my SQL...
March 7, 2017 at 12:46 pm
Viewing 15 posts - 5,836 through 5,850 (of 13,874 total)