With ssis you can

Create an sp that performs your select.

Use the sp as the source using with result sets followed by all the columns you require along with their type.

Then...

Do you mean a stored procedure that returns to 'with results set' in SSIS?

I tend to drop whatever I need to audit from the ETL process into a table, the use a BI tool (in my case, SSRS or Cognos) to produce and...

Star

Ed Wagner (11/29/2016)

---

djj (11/29/2016)

---

Manic Star (11/29/2016)

---

Ed Wagner (11/28/2016)

---

Manic Star (11/28/2016)

---

DamianC (11/28/2016)

---

Ed Wagner (11/28/2016)

---

Manic Star (11/28/2016)

---

Ed Wagner (11/28/2016)

---

djj (11/28/2016)

---

Ed Wagner (11/26/2016)

---

DamianC (11/26/2016)

---

Ed Wagner (11/26/2016)

---

TomThomson (11/24/2016)

---

Brandie Tarvin (11/23/2016)

---

Manic Star (11/23/2016)

---

Luis Cazares (11/23/2016)

---

Brandie...

In this instance I am using the sample data provided

Ed Wagner (11/28/2016)

---

Manic Star (11/28/2016)

---

Ed Wagner (11/28/2016)

---

djj (11/28/2016)

---

Ed Wagner (11/26/2016)

---

DamianC (11/26/2016)

---

Ed Wagner (11/26/2016)

---

TomThomson (11/24/2016)

---

Pacane (Spelling...

Just playing around with SCD4 as I've used a different approach previously

I'm getting:

(5 row(s) affected)

(0 row(s) affected)

Msg 515, Level 16, State 2, Line 60

Cannot insert the value NULL into column...

Use these techniques for merges a lot

Never used SCD 3 though and never used deleted

Very useful to have them all in one location

Thanks

Ed Wagner (11/26/2016)

---

TomThomson (11/24/2016)

---

Pacane (Spelling corrected; if you really pronounce it like that it's...

Recently I interviewed with a few basic generic technical questions

For the second (final) interview, I...

James Stover (4/18/2009)

---

What's a bit sad is that "borrowing" T-SQL or any other online resource is that it doesn't really help us learn better. Should job requirements say: "Must know...

Adi Cohn-120898 (4/19/2009)

---

There is a very big difference between writing a novel or creating a movie and writing T-SQL. It would be ridiculous if one day we’ll find out...

Sites like Udemy, Lynda and Pluralsight have courses that you can take and then post on professional networking sites like linked-in

The ones I have done don't come with an exam...

Exam