John Mitchell-245523 (7/19/2013)

---

Ah yes, hadn't thought of that. I guess that behind the scenes it creates a new column and copies the data across - something to bear in...

We all have that from time to time. 😀

John Mitchell-245523 (7/18/2013)

---

Koen, are you sure about that? You can add a new column with an identity property, but I can't see any way of adding the identity property...

dwain.c (7/18/2013)

---

Brandie Tarvin (7/18/2013)

---

dwain.c (7/17/2013)

---

Brandie Tarvin (7/17/2013)

---

WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly...

kapil_kk (7/18/2013)

---

I select SSDT as now when we open new SQL SERVER 2012 it comes with name Server Server Data Tool so I selected that option but still got wrong...

// accidentally hit quote instead of edit... :blush:

This is a very nice copy of this MSDN article:

Connect to a Remote Integration Services Server

Didn't notice the copyright at the bottom?

How much of the code did you copy paste? You only need to copy what's inside the main function.

All the rest is generated by SSIS and you better not tamper...

They all do the same thing, but use a different method to get there.

INFORMATION_SCHEMA are views that store metadata information about your database and if I'm not mistaken, they are...

Yes (of course if the data type allows it).

Order isn't important, that's something for the visualization layer 🙂

The order of the rows can depend on indexes on source and/or destination table and the query written to retrieve the...

You can put the ForceExecutionResult property of the data flow to success, so the data flow never fails. However, if another error occurs in the data flow not related to...

In your first post you said Unique No is the primary key. By default in SQL Server this is a clustered index, unless you specify otherwise at creation time.

Can you...

Nice question, thanks Steve!

Connect to a Remote Integration Services Server (SSIS Service)