Viewing 15 posts - 46 through 60 (of 130 total)
Just to add, I had to do it a once off, but had problems with Sybase and SSIS via ODBC, but everything worked out as soon as the Sybase DB...
May 4, 2011 at 12:02 am
Hi Brandie, ok, just saw that now, guess he must be earning commision on the sales? 🙂
May 3, 2011 at 4:34 am
We've jsut bought BI Documentor and personally I'm very happy with it. It gives you details of the SSIS package from where the field comes from how its transposed and...
May 3, 2011 at 2:41 am
Almost the same problem, but my package kept giving to following
Executed as user: SABC\Tvlicloader. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft...
April 20, 2011 at 5:47 am
When you have lots of data going around in multiple data flow tasks at the same time, it is possible that the GUI stops working all together (colors and rows...
April 20, 2011 at 1:34 am
I've seen the colours not updating correctly, specaily with loading of gig of data at a time. Its only the colours thats wrong nothing else.
April 20, 2011 at 1:08 am
I basically had the same problem, but after my big main file was written out, i would write out a small little 1bit file as well. I then check in...
April 5, 2011 at 12:47 am
Just an idea, I'm updating a table with over 240 million records on a daily basis, Generally about a million or so records per night, but may go upto 20...
March 29, 2011 at 1:43 am
As Uripedes Pants said, take a look at the reginal settings, find 1 which uses the decimal and set it to the standard on your pc and restart and try...
March 24, 2011 at 2:01 am
I have written a procedure a while back which replaces 2 space with 1 while in loop of max 30 occurances. Not rbar, but still not the best solution that...
March 18, 2011 at 12:14 am
tfifield (3/15/2011)
Using BETWEEN as a join condition is fairly common. It's really the same as using >= AND <= in either the join or WHERE clause. The efficiency...
March 15, 2011 at 11:06 pm
I'm using
exec msdb..sp_help_job
to see what jobs are running, can have a look at it as well
March 15, 2011 at 2:00 am
ColdCoffee (3/13/2011)
THis is the proc:
UPDATE P
SET P.Tax = T.Tax_Amount
FROM Products P
JOIN Tax T
ON p.amount BETWEEN T.range_start AND T.range_end
END
Just a question on the bold...
March 15, 2011 at 12:23 am
Hi guys.
It was only a suggestion, in no way intended as an answer:-)
the variable I was updating the the script was a user variable but I was thinking that you...
March 14, 2011 at 10:10 am
Viewing 15 posts - 46 through 60 (of 130 total)