I was wondering the same thing.

Nice question, I almost fell for answering third highest.

I answered correctly, told I was wrong, but the explanation matches my answer.

Oh well, at least it is Friday. 😀

I thought that was odd myself.

That seems to be what the marketing departments want you to do!

🙂

The company that I work for provides remote monitoring of various types of engines. Invariably, whenever we get a new customer, they want to be notified of every event,...

Based on what...

Is that an option in the wizard? I can't seem to find that option as part of OLE Destination Component.

Thanks,

Scott

Interesting thought. I had not checked the XML previously, but the meta data has the correct data types.

Thanks for the idea.

Scott

Nope. no triggers. I'll keep experimenting to get it to work.

Even though I still don't have it working, at least I know I am not overlooking something obvious.

Thanks for...

Sure, no problem.

CREATE TABLE [dbo].[SDELogin](

[LoginID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [varchar](60) NOT NULL,

[FullName] [varchar](118) NULL,

CONSTRAINT [PK_SDELogin] PRIMARY KEY CLUSTERED

(

[LoginID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY...

Yeah, just double checked and the identity column is set to <ignore> for mappings.

Thanks,

Scott

Unchecked. If I understand the use of the option, I would only have it checked if I wanted to specify the contents of the column, correct?

Thanks,

Scott

jcrawf02 (4/15/2011)

---

I got a really strange error:

"Your selection was rejected due to an unfiled 1058EZ-TQR form. Please consult with your tax professional within five days, or result in fines and...

tilew (4/7/2011)

---

What I don't understand, is why SQL told me that the lenght is 4, but microsoft says "the storage size, in bytes, is two times the number of characters...