Vladan (9/1/2015)

---

Hi Debbie,

I think that the problem is that you shouldn't need to update anything that is in this format. I can understand, that you create some report or whatever...

sql crazy kid (9/1/2015)

---

Error Description

[LKP - If row exists in Target [104]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record...

May I ask how you ever expected...

TomThomson (8/31/2015)

---

GilaMonster (8/31/2015)

---

A question for those who have upgraded to Windows 10 and have SQL and Visual Studio installed:

What the total size of the Windows and 2 Program Files directories?

I'm...

What have you tried so far?

Sounds like you need to open up those dataflows and make sure that everything is looking correct. Specifically, I would check the following:

1) Connections: source and destination both reachable.

2) Columns:...

Eirikur Eiriksson (8/30/2015)

---

balasach82 (8/30/2015)

---

Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than...

Answered here.

Yes.

Nilssond (8/21/2015)

---

CREATE TABLE dbo.SCHEDULES(SCHEDULEID VARCHAR(10), EFFECTIVE_DATE DATE, AMOUNT DECIMAL(4,3))

INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8202', '2015/01/01', 6.200)

INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8202', '2015/02/01', 6.225)

INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8205', '2015/01/01', 90.025)

INSERT...

Luis Cazares (8/21/2015)

---

Ed Wagner (8/21/2015)

---

Brandie Tarvin (8/21/2015)

---

Phil Parkin (8/21/2015)

---

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() -...

I don't have an answer for you, but I do have a question.

Did you consider doing this in a dataflow?

Dataflow source = (your query)

Dateflow target = suitably configured OLEDB command.

It...

Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() - 1) * 100 + day(getdate() - 1));

Haven't been following that thread, but I do have some suggestions for your query. Here's mine, derived from yours.

select ServerName = @@SERVERNAME

,JobName...

OK, and please get rid of cur2:

insert Monitor.dbo.Procedurecode

(DB

,ROUTINE_NAME

...