Strange indeed.

What if a full row comes after the half row?

GilaMonster (3/15/2012)

---

Koen Verbeeck (3/15/2012)

---

Usually I use the terms interchangeably, because there's no actual difference between the unique constraint and the unique index since SQL Server 2005. (correct me if I'm...

You're right. Usually I use the...

Yup.

I guess there are plenty of sources on the net on how to create XML in .NET.

p.s.: my guess is that you'll be begging for the temp table 🙂

Yes, if you construct the XML yourself in a script task.

Do the tables in SAP keep record of the changes somehow? (for example a LastModified column?)

Ah, I see.

I didn't know about that...

You can put a constraint on multiple columns.

However, the syntax for creating a UNIQUE constraint is as follows:

CREATE UNIQUE NONCLUSTERED INDEX [test] ON [dbo].[myTable]

(

[myColumn1] ASC,

[myColumn2] ASC

) ON [PRIMARY]

It seems there are 2 correct answers :w00t:

You mean the attachments here at SQLServerCentral?

When you create a new post, you have a button Edit Attachments in the Post Options a bit down.

Add files where? Your email attachment?

Yeah well, I once tried to log the beginning and the end of the package using Pre- and PostExecute and I was a bit surprised my package had started and...

Try using the ACE OLE DB provider (used for .xlsx). It should normally be able to read .xls as well.

What did you do exactly with the file?

If you implement error handling in the dataflow, then there is no error, it is as simple as that.

If there is no error, there is no description, so you'll have...