Viewing 15 posts - 5,311 through 5,325 (of 11,678 total)
lshanahan (8/7/2013)
At least, this is how it works from SSIS 2005. Is it different in later versions?
I don't think they changed it in later versions.
August 7, 2013 at 6:51 am
GilaMonster (8/6/2013)
Itzik Ben-Gan's T-SQL Fundamentals. Available from Amazon, there's a 2008 version and a 2012 version
+1 Any book by Itzik is well worth the read.
August 7, 2013 at 6:15 am
Maybe a little more information might be useful.
What are you trying to do?
Where are you trying to create a temp directory?
How are you trying to create it?
August 7, 2013 at 5:01 am
I see three iif functions in your expression, but there should only be two. Remove the last one.
August 7, 2013 at 4:48 am
Why not use the FTP task?
What do you do with that variable?
August 7, 2013 at 3:59 am
karim.boulahfa (8/7/2013)
I just trying that but is solve only the 2 and the third telling that the syntax is incorrect.
You forgot to put the "P" before the + in the...
August 7, 2013 at 3:48 am
Interesting question, but the explanation could be a bit better.
Thanks.
August 7, 2013 at 3:28 am
fm1618 (8/6/2013)
hey does anyone know how to customise the SSRS home page, i am wanting to add some company branding but haven't done this before, any help greatly appreciated.
faith...
August 7, 2013 at 3:24 am
Did you enable logging inside the SSIS package?
Doesn't the job history give more details?
August 7, 2013 at 3:23 am
harsimranjeetsinghwasson (8/7/2013)
Does it work with package configuration also ?
Sure. You can store the credentials in a SQL Server configuration table (which is more secure than just an XML file).
August 7, 2013 at 2:49 am
Steve Jones - SSC Editor (8/6/2013)
WayneS (8/6/2013)
August 7, 2013 at 2:47 am
karim.boulahfa (8/7/2013)
Koen Verbeeck (8/6/2013)
Try with a single =.Double == is SSIS expression language :blush:
if i do that i get a syntax error.
I think you are missing a bracket ) at...
August 7, 2013 at 2:44 am
BrainDonor (8/7/2013)
GilaMonster (8/6/2013)
Chad Crawford (8/6/2013)
They did a movie too[/url] - wasn't too good, but I thought it was worth watching because I loved the series so much.
The movie's good...
August 7, 2013 at 2:39 am
Sean Lange (8/6/2013)
If this was a QOTD I would have answered that the value of @@rowcount would be 1000. Interesting. Maybe I will have to do a little more digging...
August 7, 2013 at 1:11 am
raadee (8/6/2013)
DATABASE PROS WHO NEED YOUR HELP
Here's a few of the new posts today on the forums..
I personally do not like it, takes up a huge amount of space.
Tried...
August 6, 2013 at 3:30 pm
Viewing 15 posts - 5,311 through 5,325 (of 11,678 total)