Viewing 15 posts - 1 through 15 (of 73 total)
Well, i found this query really useful where not much hard coding is done and we are getting the exact output
DECLARE @date datetime, @tmpdate datetime, @years int, @months int, @days...
February 18, 2015 at 1:58 am
I am Sorry Phil, if at all i hurt you !!!!
but my check is that if we are really looking for the difference then this should be the output i...
February 17, 2015 at 2:11 am
Hi Phil,
Your query looks good..but can u check with this pls..I am getting the same output for the change in the value of D1
declare @D1 datetime = '20120229' -- Replace...
February 17, 2015 at 1:21 am
DECLARE @D1 DateTime = '20090128',
@D2 DateTime = '20150217';
SELECTCAST (
DATEPART(YEAR, DATEADD(Day,...
February 17, 2015 at 1:12 am
Hey Phil,
please check this link
i am looking exactly for the same !!!
February 10, 2015 at 7:02 am
Hmm...
February 9, 2015 at 5:06 am
nope ...but on click of the 'Parameterize' option, we will get the chance of selecting our own property i believe but i just have selected the connectionstring instead of other...
February 9, 2015 at 4:33 am
Let me explain,
We will have project connections in our connection manager , so i right click on them and clicked on "Parameterize" option
and selected the connection string and...
February 9, 2015 at 4:13 am
my parameter doesnt contain any expression
February 9, 2015 at 4:05 am
nope....this was checked already
February 9, 2015 at 3:34 am
HOW ?
February 9, 2015 at 3:13 am
Hi Phil,
I need another help from you , currently in our project we have given as "DoNotSaveSensitive" as the Encrypt level , suppose if the case...
February 9, 2015 at 2:52 am
That helped bro !!! Thanks for the info ..
February 9, 2015 at 2:38 am
that means .....ok let me check and get back to you
January 22, 2015 at 4:27 am
u mean to say that , dont delete the project in the SSIS DB catalog and just deploy the .ispac on the same folder in the SSISDB catalog ?
January 22, 2015 at 4:24 am
Viewing 15 posts - 1 through 15 (of 73 total)