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

...

ratloser99 36160 (8/21/2015)

---

Hi,

I like to backup the stored procedures' code used in my databases. So I created this Script:

/*

IF OBJECT_ID('[Monitor].[dbo].[Procedurecode]') IS NOT NULL DROP TABLE [Monitor].[dbo].[Procedurecode];

*/

DECLARE

@db nvarchar(50),

@strSQL nvarchar...

Try doing a Google search for SSIS IMEX=1.

It should fix your problem if you add IMEX=1 to your Excel connection extended properties.

Easiest solution: import from CSV instead.