You could 2-step it.

Create package 1 to do everything that leads up to requiring user selection. Maybe pkg sends email to users that their action is required?

Create user selection...

Either add an "approved" column or determine logic for deciding what values in the existing fields make a customer approved.

When I set up the SQL Agent job for the package step, there is a tab for datasources and I've found the connections "float up" so I can select the...

we also use file system. quick and easy to backup.

I agree that clear-headed, new look is always helpful!

for future reference, I've found that

ISNULL(field) == TRUE yields consistent results.

I'd suggest you check your data source view to be sure you have the linkages correct.

We don't allow nulls in our underlying dw tables so when I get nulls, I...

Script component uses VSA so is easier to learn if you aren't a C coder.

I personally would start over with the script component and toss what you found. Debugging...

make it a string. break it into 2 parts and stick a decimal in there, then convert back to desired numeric data type.

battery_acid_h (12/29/2011)

---

My client wants either a measure or a calculated dimension to handle the following in a sales cube:

a customer buys a certain product on a specific day and will...

I'd let the end user tool handle it vs in the data warehouse. There are plenty of tools that can add KPI.

I'm sorry, I don't at all understand what the problem is?

I get lost when you are talking about executing on a client pc. All of our SSIS packages execute at server level. Are you creating a client utility...

We know it will crawl but since it's part of the ETL for the fact table, we need to attribute the payments in the same package. That's also where...

I don't think regular ADO connection stuff works here since that doesn't take into account the confines of DTS. I've done some script components before so do understand the...

http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

This link should get you started.