Using your conditional split, you have one output for when the has changed. Connect this to a derived column and set the city column to NULL.

Yes, because with scripts you would have to use linked servers. SSIS will be faster.

FILESTREAM is for storing BLOB data, such as images or PDFs, not for storing the data in individual columns.

brad.mccollum (4/3/2014)

---

None at all of the examples I am finding actually work once I implement and modify the code for my particular situation. It only seems to loop through the...

Abhijit More (4/3/2014)

---

We are saving mapping in below format. The other approach is saving it in vertical format.

File NameCol1Col2Col3Col4

File 1.xlsField1Field2Field3Field4

File 2.csvField1Field3Field2Field4

File 3.xlsField4Field3Field2Field1

File 4.tabField2Field4Field3Field1

The only constraint we faced here is using...

suba.sathyanathan 40131 (4/3/2014)

---

The indexes are appropriate. I looked at the query plan in one of the other env where there is relatively lesser data. It seems to do an index...

My guess is that when using the date parameter, there isn't an implicit conversion and the index is used.

Just a guess though 🙂

You should take a look at the query...

Nice question, thanks.

If...

Can you write some pseudo code that illustrates what you are trying to accomplish?

No, sorry.

GilaMonster (4/3/2014)

---

Koen Verbeeck (4/3/2014)

---

GilaMonster (4/3/2014)

---

Jeff Moden (4/2/2014)

---

Koen Verbeeck (4/2/2014)

---

GilaMonster (4/1/2014)

---

In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is...

If the databases are on the same server, you can use SQL scripts.

Make sure logging is minimized to reduce overhead.

What kind of performance issues were you having with the denormalized...

GilaMonster (4/3/2014)

---

Jeff Moden (4/2/2014)

---

Koen Verbeeck (4/2/2014)

---

GilaMonster (4/1/2014)

---

In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less...

The book Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution describes such a scenario.

Basically you do everything in a .NET script task.

You check the file type, choose the corresponding...