There's no attribute called InvoiceNo in your XML. That is, there needs to be something like this:

<Invoice InvoiceNo="12345" />

Well, what DO you want to do with extra columns? Ignore them, process them specially? This is really a business question, I think. What do your customers...

Use a CS or script transform to check the format. Don't assign columns in the flat file connector.

How would the package recognize that the for has fewer or more columns? If it's obvious you can use a conditional split. The idea is to have the flat file...

It is dyi version of a recvursive cte but avoids the rbar problem and potential exponential runtime

Yup!

crazy_new (9/2/2014)

---

Just a quick question. In the inserted/deleted tables, does it contain all of the records of the last single transaction made? And if I use set based logic,...

crazy_new (9/2/2014)

---

In this specific situation your will never be able to add more than one, because this trigger is just for two people on a single client, one is a...

crazy_new (9/2/2014)

---

Im not using that @PAMID variable anymore..just forgot to take it out before I posted the code. This trigger will fire for every insert. Is it possible for two...

I'm not sure how "Labor Day 2014" can be returned. I don't see the string "Labor Day" anywhere in the function.

I'm sorry if you are offended. I suppose I'm simply confused.

If you have verified the accuracy of your data before sending it to SQL Server, why do you want to...

Your original post included a screenshot that looks like a windows application. Are you working on that application? If so, I would do the validation there and not...

questions:

1. are you checking in your application first? (why send bad data to SQL?)

2. What have you tried so far (you need to make some effort here.)

Jeff Moden (7/28/2014)

---

gbritton1 (7/28/2014)

---

Jeff Moden (7/28/2014)

---

gbritton1 (7/28/2014)

---

Jeff Moden (7/28/2014)

---

g.britton (7/27/2014)

---

Much better to use a date dimension table that contains all relevant date info for your company. You can include...

Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as well as fiscal...