Calling someone boring just because they can't script is a bit harsh!

And the answer to (A) is that there will be no issues installing it on the same server.

Though if it's a production SQL server, you would normally not install...

Grant Fritchey (5/15/2015)

---

Vyper426 (5/14/2015)

---

I Really appreciate everyone who contributed information. I must also apologize for neglecting to let everyone know the other issue that brings me such joy in this...

Local instantaneous? That's fast!

metroman17 (5/14/2015)

---

I am trying to get the servername into a sql table.

Sql:select @@servername as ServerName as SQL command.

The above sql is part of OLE DB Source

The OLE DB Destination has...

An interesting read, thank you very much. Hope you don't mind me mentioning a few minor typos:

'FacTransaction_ColumnStore' – needs an extra 't'

'Compression ration' – ratio

'foorprint' – footprint

'datawarhouse' – missing 'e'

'which...

tom.w.brannon (5/13/2015)

---

Yes, intersect is not normal to me either. I actually changed it where exists and then used except. Still non-obvious logic for me so I am glad...

The proposed data structure is not pleasant, from a relational standpoint. You should never have repeated occurrences of people's names, for example. And rows 3 and 4 of your desired...

RantaSanta (5/13/2015)

---

Tried the steps , its still failing with same error . I have tried with one package out of five package . Driving me nuts . I can open...

This sounds very likely.

vipin_jha123 (5/13/2015)

---

Hi According to me Checkpoint is used to restart the package from the point point where it fail.

so u can seee that when your package failed one files are...

reddychaitanyakrishna (5/13/2015)

---

Hi,

I have a DFT in a package which loads around 2lakhs records in to destination but, it fails loading after 1 lakh records, my package was checkpoint enabled. I...

This is not a version issue. This relates to the fact that you saved the package with encrypt sensitive with user key turned on. if you save the package as...

sreenubabu.s (5/12/2015)

---

We have installed recently SSRS 2014 (SQL 2014 RTM) and deployed the reports into the server and all users being accessed. We have done memory configuration in config file...

Something like this?

if object_id('tempdb..#date', 'U') is not null

drop table #date;

create table #date (a int, b int, dte date);

insert #date

(a

...