Can't use a script task, this is in the data flow. I cannot just update or merge join.

Specifically, I have payments that must be attributed to one...

I think the questions you ask would mostly get an "it depends" from me, as it simply depends on your design, performance targets, optimizations,etc., and environment. There simply is...

Why not walk the code of one they have created? If they have standards and conventions, it will be best to get learned on their procedures.

"the projects relate to each other then i think its good to put them in the same solution, for example SSIS/SSAS/SSRS projects all relating to one BI solution.

but for projects...

if you are simply documenting, notepad, wordpad, openoffice.org

or prevent the error from occurring at all by only accepting valid entries into the dataflow and/or specific component.

a text entry is not at all the same as a null...

well, there you go. truncation.

not sure I'm clear on the problem, but if you are seeking to put two data streams together, a merge or merge join will accomplish this for you.

Otherwise, since you...

Can the process that fills TxtMaster also handle the column transforms?

could you instead use a sequence container that won't move to next step until all inside are done?

Gees, Drew, sorry to piss you off so thoroughly.

How is it better? it will work.

I recently spent many months interviewing and never ran across that question. partially because it's pretty vague!

You are better off acquainting yourself with what SQL does and...

Yep, OLE Automation is your answer. Look into creating Access databases programmatically. Presumably it can be adapted to SSIS but I've not done it except from VBA.

how are the users selecting the dates? If you control their interface, put the logic there, where they are making the selection.

Apologies if not helpful for SSRS...

I think Ryan is onto something. I'm not sure you need a full on data warehouse, nor have the time, etc., to build one, but, a reporting server could...