Viewing 15 posts - 6,091 through 6,105 (of 13,874 total)
Steven.Grzybowski (1/11/2017)
When I open up the script task is SSDT editor, I see the what is in the attached screenshot.
OK, now I know what you mean. Though they look...
January 11, 2017 at 10:19 am
Steven.Grzybowski (1/11/2017)
The script task works fine...
January 11, 2017 at 9:47 am
homebrew01 (1/11/2017)
I think our server's OS is not compatible with the Upgrade Advisor. I think the minimum OS is SQL2008 R2, but we're on R1.Suggestions ?
Based on this doc, you...
January 11, 2017 at 9:33 am
Luis Cazares (1/10/2017)
ZZartin (1/10/2017)
January 10, 2017 at 2:09 pm
bsbabu2008 (1/10/2017)
Thanks for your reply,
But we can't see 32- bit version (Standard edition ) in Microsoft Volume License Server center and one of Microsoft support executive say's that...
January 10, 2017 at 1:25 pm
Looks like 2014 was the final 32-bit version.
Check this page: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx#Hard Disk Space Requirements (32-Bit and 64 Bit)
January 10, 2017 at 12:32 pm
Makes me wish I'd called the boss after I got up and asked to telework for the day...
This is the sensible option. I had to do it last Thursday when...
January 10, 2017 at 9:32 am
If it were completely a Dataflow though, then SSIS should roll back any inserts it had already done if one failed.
By default, yes, but not necessarily.
January 10, 2017 at 8:15 am
Kannan Vignesh (1/8/2017)
Hav a good day.
i need a clarification regarding usage of checkpoint in SSIS.
i set a checkpoint for single task. in this task , trying to insert a 1000...
January 8, 2017 at 12:39 pm
OK, here is some code which may help you. It won't run as it stands, but it might help you understand how I got data back from Facebook using OAuth.
Firstly,...
January 8, 2017 at 9:43 am
JasonH-ITG (1/6/2017)
January 6, 2017 at 2:02 pm
WITH cte
AS
(
SELECT tbl1.Date, tbl1.ID, tbl1.Order_Amount, tbl2.StoreNum, ct = COUNT(tbl1.id) over(partition by tbl1.id)
FROM tbl1 right join tbl2
ON tbl1.ID = tbl2.ID
)
SELECT * FROM cte
WHERE ct > 10
I suspect the problem was...
January 6, 2017 at 1:42 pm
JasonH-ITG (1/6/2017)
Phil Parkin (9/14/2016)
If anyone else has experienced this, it would be interesting to know.
Sorry for replying to an old post, but THANK YOU! This fixed the issue for...
January 6, 2017 at 1:38 pm
mikevessey (1/6/2017)
nobody said you had been tripped up... in fact I said that I had been tripped up before
in sql 2000 days people always said PHYSICAL storage order. most...
January 6, 2017 at 10:55 am
Viewing 15 posts - 6,091 through 6,105 (of 13,874 total)