Viewing 15 posts - 4,801 through 4,815 (of 13,877 total)
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
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
So how do you determine which years are required for each ID?
January 12, 2018 at 3:07 pm
chrisjgreen08 - Friday, January 12, 2018 2:26 PMID comes from a table called 'Name'. It's a unique VARCHAR field.
OK, and does this...
January 12, 2018 at 2:29 pm
Viewing 15 posts - 4,801 through 4,815 (of 13,877 total)