Why not cut your losses? Create two ExecuteSQL tasks and run one after the other.

And here it is again for those who would prefer to see the query formatted:

select @QTY_cost = (select round(sum(QTY), 0) QTY

...

sandhuz24 (5/18/2015)

---

Greetings All

So I am in a predicament. Hopefully, experts here might be able to solve this for me.

I need to move data for some specific tables from Server1 to...

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