Viewing 15 posts - 5,131 through 5,145 (of 11,678 total)
hitesh.ramchandani (8/16/2013)
Koen Verbeeck (8/16/2013)
anil.kumars13 (8/16/2013)
Thank you, I came up with the same issue. but got it resolved by your post.Thank you,
Anilkumar
Remember that you now gave everyone full access to your...
August 16, 2013 at 2:55 am
I don't think there is something similar at this site, but it would make an awesome feature.
August 16, 2013 at 2:50 am
Would you get any benefit if the data is sorted according to ID and empNo?
August 16, 2013 at 2:19 am
In my data warehouses I usually have three logins: an administrator group, a reader group and a writer group. I give permissions to those groups and it is up to...
August 16, 2013 at 2:18 am
I said use IS NULL to compare.
For example:
CASE WHEN myColumn IS NULL THEN do something ELSE do something else END
You cannot compare columns directly with NULL (myColumn = NULL will...
August 16, 2013 at 2:13 am
anil.kumars13 (8/16/2013)
thanks for sharing the informationso, what we have to do to give access to particular user, who can run the job as well.
Thank you,
Anilkumar
Use proxies in the SQL Agent...
August 16, 2013 at 1:47 am
Just add another CASE statement where you check if the expression is NULL with IS NULL. If it is, use the expression m / tt. You might want to put...
August 16, 2013 at 1:46 am
anil.kumars13 (8/16/2013)
Thank you, I came up with the same issue. but got it resolved by your post.Thank you,
Anilkumar
Remember that you now gave everyone full access to your data in the...
August 16, 2013 at 12:57 am
This makes me wonder when Gail will reach the SSC Guru level 🙂
August 16, 2013 at 12:13 am
Apparently a bug in the total leader board not showing the correct levels above SSChampion.
If you go to the thread mentioned in the reference, you see the correct level with...
August 16, 2013 at 12:13 am
Jan Van der Eecken (8/15/2013)
Koen Verbeeck (8/14/2013)
ChrisM@Work (8/14/2013)
... Not bad for a European.I shall take this as a compliment! 😀
Hartelijk gefeliciteerd, Koen.
I need to start posting more replies so we...
August 15, 2013 at 1:58 pm
Phil Parkin (8/15/2013)
jbowers (8/15/2013)
August 15, 2013 at 12:58 pm
Phil Parkin (8/15/2013)
mtassin (8/15/2013)
Nice article. I hope you'll at some point discuss the headaches of managing the execution logs of projects deployed to SSISDB. 🙂
Especially with the...
August 15, 2013 at 12:57 pm
s_osborne2 (8/15/2013)
I only use the wizard if I have to transfer hundreds of tables and I'm too lazy to create the data flows myself.
So i guess BIML will become your...
August 15, 2013 at 12:49 pm
There's no benefit of creating a master package for just a single child.
However, if you have a lot of child packages, you can let them all run in parallel, cutting...
August 14, 2013 at 2:54 pm
Viewing 15 posts - 5,131 through 5,145 (of 11,678 total)