Viewing 15 posts - 4,801 through 4,815 (of 13,876 total)
Instead of this
WHERE NOT ((@OldValue IS NULL AND @NewValue IS NULL) OR (@OldValue = @NewValue))
Try this
WHERE NOT EXISTS (SELECT @OldValue INTERSECT SELECT @NewValue)
January 18, 2018 at 11:16 am
I have spend lots of time reading the articles but not finding it very conclusive....
January 18, 2018 at 10:37 am
January 18, 2018 at 10:25 am
January 18, 2018 at 10:01 am
Below is my requirement. I have given the one material number YHE30B21S as...
January 18, 2018 at 9:51 am
I have a unique situation where i need to execute all the SQLs sitting in...
January 18, 2018 at 9:39 am
^^ I agree with John.
Note that there is no need to precede a THROW statement with a semicolon.
January 18, 2018 at 5:21 am
Standard practice is to use Don't Save Sensitive and then use SSISDB environment variables to pass sensitive parameter values.
January 17, 2018 at 2:03 pm
Note that it's been called SSIS, not DTS, since 2005.
January 17, 2018 at 2:01 pm
So I suggest building your SQL dynamically via a package variable with an Expression and using that as the source for the ExecSQL task.
January 17, 2018 at 1:13 pm
You cannot run anything more than very simple SQL against an Excel connection. The parameter stuff is probably causing the problem.
January 17, 2018 at 12:59 pm
January 16, 2018 at 1:53 pm
January 15, 2018 at 8:07 am
Select ContactID, Name
FROM dbo.TableA
IN Lookup Transformation I need to pull...
January 15, 2018 at 7:35 am
January 15, 2018 at 5:27 am
Viewing 15 posts - 4,801 through 4,815 (of 13,876 total)