OK, now I know what you mean. Though they look...

Steven.Grzybowski (1/11/2017)

---

I have built a Script task in an SSIS package on my workstation. The script task has 2 files - ScriptMain.cs and http://FTP.cs.

The script task works fine...

Based on this doc, you...

Luis Cazares (1/10/2017)

---

ZZartin (1/10/2017)

---

There's certainly nothing stopping you from using columns in one able to reference another table without making it an official foreign key. You would just have...

bsbabu2008 (1/10/2017)

---

Hi,

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...

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)

This is the sensible option. I had to do it last Thursday when...

By default, yes, but not necessarily.

Kannan Vignesh (1/8/2017)

---

Folks,

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...

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,...

Do you have a question?

JasonH-ITG (1/6/2017)

---

Nope, not in my case; it had persisted between restarting SSMS and reboots. It was only occurring on one of my servers; workstations and other servers did not...

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...

JasonH-ITG (1/6/2017)

---

Sorry for replying to an old post, but THANK YOU! This fixed the issue for...

mikevessey (1/6/2017)

---

hey,

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...