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

You could think of each of these as a service, that service is still a product. Even if it is a unwanted good, it still generated a line item of...

Thanks for your responses. I am also looking for a good resource on WQL, if anyone has any suggestions.

Thanks.

Thanks Ells. I will try that suggestion, using a script task with a variable. I was just curious if there was some issue with the query I have and why...

True...

What version of Excel are...

Hi,

Is there any one that can offer any advise?

It would be much appreciated. Thank you 🙂

I was thinking also there are times when a business would get accounts from a client with the client's key (account #)for that account. You would create your own...

Phil Parkin (11/7/2014)

---

MMartin1 (11/6/2014)

---

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox....

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is a...

DonlSimpson (11/6/2014)

---

Actually, this is not correct. E.F. Codd introduced the concept of surrogate...

Using the wizard ...

Depending on the relationship of the tables, you can also then group the individual Data Flows (DFs) together into sequence containers and run those serially, with the...