Viewing 15 posts - 1 through 15 (of 82 total)
The SQL Scripts addin won't install if you are running SSMS 2016. Presumably that version isn't included in its known versions list.
August 16, 2016 at 2:03 pm
I've added code to my application that logs whether it's running in 32 or 64 bit mode (example shown below, using Msgbox in place of my logging function).
Setting Run64BitRuntime to...
July 31, 2016 at 3:18 am
Thanks. I thought I had already set that, but it must have been on a different test. Then I couldn't find how to set it; I was looking...
July 26, 2016 at 8:17 am
Typical - I've spent 3 days trying to fix this problem, including much use of Google before posting here for your erudite investigation, and shortly after posting I found a...
July 25, 2016 at 3:43 pm
This does seem a complex way to do it - though it does let you log the results in an SQL table if that's important to you.
Personally, I use two...
July 30, 2015 at 7:58 am
As this thread has woken up again, and as SSCrazy mentioned running 7-Zip in SSIS, here's one way to do it in .NET code, in this case to extract the...
July 26, 2012 at 4:46 pm
Good grief, that's a complicated way to do it. As you had to write .NET code anyway, why not do the whole thing in a single script task, (or...
June 20, 2012 at 3:44 am
I too wondered why you didn't use MERGE; I see you answered that by saying this was a method you had developed under SS 2005, which didn't support SQL MERGE.
I...
June 13, 2012 at 12:44 pm
I use WITH RECOMPILE or OPTION(RECOMPILE) quite often; the latter is what you use when you only want to recompile an individual query within a procedure. You put it...
June 7, 2012 at 3:22 am
The article describes how to do this in Open Visual Studio 2010.
Is it possible to do the same in the version of Open Visual Studio 2008 that comes with SQL...
April 5, 2012 at 4:18 am
Once you have started writing a script, you can't change the language in that task.
What you'll have to do is create a new script task, set the language you want...
March 28, 2012 at 8:52 am
The File Watcher Task is a new one for me; could be useful in future. At present, my ETL tasks run once or twice a day and as Phil...
January 5, 2012 at 6:37 am
I see that even if you set
@v1 sql_variant = cast ('15.00' as float(53)),
@v2 sql_variant = cast ('16.00' as decimal(18,4)),
which makes
v1 v2
1516.0000
SQL Server still says v1 >...
December 1, 2011 at 4:19 am
Thanks Martin - but as you'll realise those are not ideal solutions!
I had not thought of 1), but I don't want to do that as I don't think it's good...
November 18, 2011 at 11:15 am
I am sure it's not due to one of my changes. Because 1) I reverted to an earlier version this morning, from when it all worked, and got the...
November 18, 2011 at 5:45 am
Viewing 15 posts - 1 through 15 (of 82 total)