OK, this answer contradicts the earlier one.

So ... you want to identify rows where another row exists which is 'similar'.

'Similar' here means that all...

monilps (1/13/2016)

---

Hi,

I need to identify possible duplicate (not exactly duplicate row) data without primary key:

Table A:

Col1 ...

Please explain how the 'customized' figures are determined.

Letron Brantley (1/12/2016)

---

Phil Parkin (1/12/2016)

---

I just read through the link you suggested. It suggests that the parallel loading of a table will work if that table is a heap. Otherwise...

JustMarie (1/12/2016)

---

Letron Brantley (1/12/2016)

---

JustMarie (1/11/2016)

---

To address the situation of gap fill or other re-run situations I use a parameter table.

One package to populate the parameters.

One package to pick up the...

Letron Brantley (1/12/2016)

---

I have a question regarding the Microsoft Balanced Data Distributor.

http://blogs.msdn.com/b/sqlperf/archive/2011/05/25/the-balanced-data-distributor-for-ssis.aspx

Does anyone have any insight into how SQL Server handles target table locking if you use the...

Please provide some sample data in easily consumable format, as described in the link in my signature.

declare @HearingDate datetime = '20011006'

Declare @HearingTime varchar(5) = '0830'

select @HearingDate + cast(stuff(@HearingTime,3,0,':') as datetime)

With over 1,000 posts, you should know by now that 'SSCommitted' is not Jacob's name 🙂

Why not use a native C# application? What benefits do you think that SSIS is giving you?

And if you are trying to choose between VS2012 and VS2013, I'd recommend VS 2013: it's newer and (IMO) better.

Eric M Russell (1/11/2016)

---

You probably already know this, and you didn't specifically mention SCD or if this is a MERGE versus straight INSERT into Destination, but avoid using the SSIS...

Orlando Colamatteo (1/11/2016)

---

Phil Parkin (1/11/2016)

---

Orlando Colamatteo (1/11/2016)

---

For SSIS I was thinking more along the lines of this:

1. Execute SQL Task gets all IDs needing to go into the file and...

...that would be the most efficient, but the only problem is that if there was an issue with a load that day where it failed, manual intervention would need to...

Orlando Colamatteo (1/11/2016)

---

For SSIS I was thinking more along the lines of this:

1. Execute SQL Task gets all IDs needing to go into the file and stores in SSIS variable...