Thanks for your hint! I used a calendar table and DENSE_RANK() as shown in the article to solve my problem. I appreciate your help very much.

If you need to look at previous or next records in a set, use LAG() or LEAD() with an OVER clause. then you can use conditional logic to see...

I'm guilty of using Int for SSN a long time ago (and I'm not from the US). You can imagine that was short lived!

g.britton (10/6/2015)

---

This is a good start, however I do not see any error handling. Do you just let the package fail? If so, how would you troubleshoot a...

Honny (10/6/2015)

---

Its my suggestion ,In case of using two Derived Column and one Data Conversion in between source and Destination, it is performance Factor .When we are aware of length...

t.pinder (10/6/2015)

---

Sam, I'm sorry, this sentence doesn't...

g.britton (9/10/2015)

---

I just used BIML for the first time in a new project. Pretty pleased with the results except for one thing:

It's really hard to get help! I...

By un-pretty I mean you'd have to type BIMLScript without intellisense and proper formatting in Visual Studio.

1. BIML might be free but to use it in anger you will need to install Mist which is not cheap at $4000 per licence plus annual support costs.

TheComedian - No, I don't have experience with Theobald. If you need help, try posting on Biml forums and I'm sure one of the guys will help you. Link is...

TheComedian (7/13/2015)

---

^I agree; this is interesting but I can't see your average developer using this tool since one of the points of SSIS is to get away from C#and XML....

nzhang6666 - Huh! My attempt to write an elaborate article so even people new to Biml would be follow may have caused you to feel that this is complicated. This...

Thanks for the kind words! Glad you liked it.

Chris, I hope you mean something like a...

I don't disagree. I think these are two different ways to do it. I've used both of them. And I think I said it in the article, this step of...