Scott Coleman (2/6/2014)

---

I was just making the observation that the original post did not say where the data was coming from or where it was going. However clever the...

You seem to be...

battula.ramu6 (2/6/2014)

---

When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display " " if the result of calculation...

chetan.deshpande001 (2/6/2014)

---

Would it be ok for you to use recursive CTE ? ..something like

--Edit

I'm sorry for the formatting/colors ..as this is my first post and do not know how...

Certainly a good opportunity for you to learn. I am no PoSh guru by any...

martin.hock (2/6/2014)

---

Hi Phil,

27 at the moment, number increasing.

The most comfortable solution would be a table stored on a master server, from where the batch file fetches all information, which packages...

Out of interest, how many...

I tried the UNPIVOT transformation for this problem and after pratting about with it for a while in an attempt to make it work, I have come down soundly on...

Evil Kraig F (2/5/2014)

---

Phil Parkin (2/5/2014)

---

+1 to Lempster's answers, I agree with them all. Though I would more strongly recommend using the project model in 2012 - been using it...

+1 to Lempster's answers, I agree with them all. Though I would more strongly recommend using the project model in 2012 - been using it for about a year and...

Can you post the T-SQL of the query from your ExecuteSQL task please?

jameslauf (2/4/2014)

---

Hello I need a little more help with the SQL task to Variable.

I have made a SQL Task and set the result to Single Row and put in my...

jameslauf (2/3/2014)

---

New to SSIS have done mostly Import Export wizard jobs with small modifications.

I have a Flat File Source that has 30 columns and a Destination Table that has 31...

Perhaps you could try this.

1) Send all of your potential updates to a staging table.

2) Do a Merge from the staging table to perform the update using a source something...

DaveDB (1/24/2014)

---

This comment is very insulting.

"Perhaps the reason for my request for additional material is becoming clearer now.

The fact that accomplished professionals, who would usually be able to...