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

Alvin Ramard (1/11/2016)

---

I can see a way of doing this in SSIS, if the output is a text file with one or two columns.

What's I'm visualizing is rows in the...

bpowers (1/11/2016)

---

Well after submitting the SSIS file for testing I was notified that the Header and Detail must be grouped together. Ughhh... If you still have a bcp option you'd...

Ed Wagner (1/11/2016)

---

Koen Verbeeck (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Grumpy DBA (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus...