Only row 2 is ignored, because it is the only one which matches your exclusion rule.

You have said that rows 2 and 3 will be ignored (why row 3, its...

Nevyn (10/23/2013)

---

I suspect that this requirement would be way easier to do loading the data into a staging table and then using T-SQL.

Maybe some more veteran SSIS users have a...

2008

I don't believe the above approach will work because there could be multiple Acquired/Lost combinations for a single Auid (sorry, should have explained that in my original post). For...

Although I didn't specify, the re-acquire method is exactly what I was looking for. Thanks much for posting!

I was able to achieve what I wanted by doing the following:

1) Added List control to report body. By default, a Tablix report item is created within the List...

Jeff Moden (12/21/2011)

---

MattieMich7 (12/21/2011)

---

I figured it out. Here's the code:

create table #Table1 (ProjectID int, [Attribute Name] nvarchar(50), DateTimeValue datetime)

insert into #Table1

select 1,'Start Date','8/8/2008'

union all

select 1,'End Date','4/30/2011'

union all

select 2,'Start Date','10/1/2011'

union...

I figured it out. Here's the code:

create table #Table1 (ProjectID int, [Attribute Name] nvarchar(50), DateTimeValue datetime)

insert into #Table1

select 1,'Start Date','8/8/2008'

union all

select 1,'End Date','4/30/2011'

union all

select 2,'Start Date','10/1/2011'

union all

select 2,'End Date','9/30/2014'

;with...

Thank you both for your reply. I'm sorting through the examples now (kind of information overload, but I'm definitely learning a lot) to see how I can apply it...

Since my goal was to never remove the duplicates, I realized that the Multicast transformation was the best fit for my needs.

I have one Multicast output that sends...

Thank you for your reply.

However, I'm not looking to "remove" duplicates through a conditional split. I just want to identify them and export them to some kind...

I continue to be unsuccessful in my search for a solution...any takers out there?

Thanks again!