caojunhe24 (11/10/2015)

---

Hi all experts,

I'm trying to schedule a job using SQL JOB AGENT

The logic- the SSIS package should run on every

Monday :12pm-10pm..(should run every 30 mins)

Tuesday 8am-9pm..(should run every...

jarid.lawson (11/10/2015)

---

I'm better than this! I KNOW I'm better than this. Just the same I am hitting a brick wall, and I could use an extra set of eyes to...

I received notifications.

You did the right thing.

Did you read the message at the top of the home page?

Been there seen that, but don't know of any way to avoid the high memory usage.

FYI, limiting SQL Server to no more than X MB will not help in any...

Lowell, you reminded me of one of the most honest sign I saw a homeless person holding.

It said: "NEED BEER!"

😀

Reread ...

[p]

...The current user cannot decrypt secrets from the package. This scenario can occur if the current account or the execution account differs from the original package author, and...

For changing ownership, take a look at:

https://msdn.microsoft.com/en-us/library/ms173423.aspx

Lynn Pettis (10/21/2015)

---

Determine if ColumnA has duplicate values:

select

ColumnA,

count(*)

from

dbo.MyTable

group by

ColumnA

having

count(*) >...

GilaMonster (10/21/2015)

---

Grant Fritchey (10/21/2015)

---

GilaMonster (10/21/2015)

---

Grant Fritchey (10/21/2015)

---

There are sessions that we...

Grant Fritchey (10/21/2015)

---

GilaMonster (10/21/2015)

---

Grant Fritchey (10/21/2015)

---

There are sessions that we get...

Blame Windows.

Jeff Moden (10/20/2015)

---

Alvin Ramard (10/20/2015)

---

Lynn Pettis (10/20/2015)

---

Remember, the OP is working with SQL...

Jeff Moden (10/20/2015)

---

This problem deserves "KISS". 😀

--===== Setup the test. This is NOT a part of the solution.

DECLARE @testTime CHAR(5);

SELECT @testTime = '23:45';

--===== Exploit the simplicity of implicit conversions...