Looks tidy to me.

It's satisfying how you can do so much in C# with so few lines of code.

rk1980factor (5/5/2016)

---

Hello,

I am trying to write simple case statement based on attached spreadsheet. please see the attached document. It is both in xlsx and zip format.

Here is the copy paste...

skb 44459 (5/5/2016)

---

I would like to write a Select Statement, which will bring additional columns from different databases based on the value of Column.

Select

Site, Trans_num

case

...

Regarding the 'check-in' process – are you using an in-house system for all of this? Or a standard VCS?

Perhaps this would be of interest. Note that I have no connection with this company.

Ed Wagner (5/3/2016)

---

Lynn Pettis (5/3/2016)

---

Luis Cazares (5/3/2016)

---

Ed Wagner (5/3/2016)

---

I guess I'll agree with your agreement...

ScottPletcher (5/3/2016)

---

You need to create an index on ID in T2, T3, T4, T5 and T6.

You should check the tables in the order of most likely to EXIST first, so...

Maddave (5/3/2016)

---

I'm a relative novice with SSIS, but I'm trying to get my head around the best way to do this.

I have a number of CSV files that always...

Smendle (5/3/2016)

---

OK. This relies on the number of columns being known in advance and the data types also being known.

SELECT 'Car','Boat','MotorCycle','Scooter' FROM T1

This returns a row of data containing...

Jeff Moden (5/3/2016)

---

djj (5/3/2016)

---

Had a "discussion" today. Developer asked I push a couple stored procedures. No problem, this happens all the time. Looked at the SP's and saw...

Smendle (5/3/2016)

---

Phil Parkin (5/3/2016)

---

Smendle (5/3/2016)

---

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe...

Smendle (5/3/2016)

---

You can do this within SSIS. Its a populate SQL from variable, while the column names don't have to be the same I do believe the number and...

mitra.itha (5/3/2016)

---

Hi All,

I have an urgent requirement in SSIS Package , I want to get the table list from a configuration...

What special functionality does this assembly give you? Perhaps there's been a change in assembly name.

First things first: protect the data. Get him to get backups and to restore them on another server to verify them.

Then ensure that regular backups are in place.

Then think about...