ipisors (8/11/2014)

---

I was able to solve this because eventually I realized that I needed to drag a flat file destination, not a flat file source. Seems obvious, but the...

daniarchitect (8/11/2014)

---

Hello SQL families,

What is the maximum one can make as SQL / BI developer? Or How far a Microsoft SQL developer can go?

the More senior you become in...

Nice question, thanks.

That's a new one, aside to the questions asking for exam dumps and free copies of books.

chrisn-585491 (8/11/2014)

---

So do I need to search Google with segments of multiple blog postings on his blog and try to find the copy right holders?

Who owns copy right...

I think to only action you can take is notify the actual owners of the copyright. It is up to them to take action.

Indeed, you can work with SSDT just fine without having SQL Server installed.

No, your code takes a date and creates a mmddyyyy representation.

But if SSIS mixes up days and months, it can lead to the same issue (e.g. creating yyyyddmm by accident...

Ah, LEFT is probably introduced in...

Phil Parkin (8/11/2014)

---

As long as the string is three or more characters,...

paul.knibbs (8/11/2014)

---

Jeff Moden (8/9/2014)

With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia, explain or even...

It should affect all dates I assume.

Maybe because the other dates are impossible in a given format (months cannot be over 12), SSIS assumes another format?

Usually I steer away from...

You use the LEFT function.

The expression looks fine to me.

So you are saying the issue happens for a single date, but not for all the other dates? Seems quite odd to me.

Check the regional...

Why don't you leave the current date from the source - MaturityDate - as it is and insert that into the database.

You can convert it to the format you like...