rhythmk (11/18/2014)

---

Not yet Koen.Actually this is PROD server and not maintained...

The reason the dataflow does not work inside a for each loop container, my thinking, is that every column passed through the dataflow data buffers has a unique lineageID. ...

I dont think temporary tables have anything to do with the inability to return results to excel. I dont think you need to avoid them. The final select in the...

iammichaelclark 21625 (11/18/2014)

---

Hi,

I am having two columns with the money datatype values.

Column1 Column2

$134,456 $15,897

$123 ...

Eirikur Eiriksson (11/18/2014)

---

serg-52 (11/18/2014)

---

kriskumark96 (11/17/2014)

---

Hi,

The three queries is of the same tables with different where condition are used , so that we cannot have a join or cross join on...

The first thing that stood at at me was that you want to invest in new infrastructure rather than investigate the cause of report slowness. I do like the idea...

On the SSRS server you can reach the firewall settings through the control panel.

I am curious as to what changed two weeks ago from your post. I would talk...

This might help comparing the versions

http://msdn.microsoft.com/en-us/library/cc645993.aspx

For an older version you could search Ebay though I am not knowledable on the legals of transfering licenses.

From MSDN,

"For a database under the full recovery model, all row-insert operations that are performed by bulk import are fully logged in the transaction log. "

http://msdn.microsoft.com/en-us/library/ms190422(v=sql.105).aspx

A Bulk Insert is...

Jeff Moden (11/17/2014)

---

MMartin1 (11/17/2014)

---

dogramone (11/16/2014)

---

Are you making a stored procedure call here? I'd recommend it and then make the first line "set nocount off" and the last "set noucount...

You approach doesn't account for when you have a valid reason to insert the data again. Such would be the case when you got the original file with some or...

Just to cover this, how did you conclude there are members missing? Does the process that moves the data from the flat file truncate the table before loading it (by...

Assuming the item name can indicate a leaf level part... might this be what you are looking for

with MstrTable as (

SelectBom.Compitemno

, 1 as [level]

fromBOM

whereBOM.CompItemno = 'Parent1'

UNION ALL

SelectB.Compitemno

, MstrTable.[LEVEL]+1...

I am wondering if it could be a firewall issue or an issue connecting from SSRS to the Exchange server. Also, did a password for some service account get changed...

dogramone (11/16/2014)

---

Are you making a stored procedure call here? I'd recommend it and then make the first line "set nocount off" and the last "set noucount on". This...