I would use a failure contraint and add the actions on that 'branch'.

Are you wanting to redirect the row that caused the error or the entire file?

I would have to agree with SQL Runner. Those are some broad questions. I would recommend picking up The Data Warehouse Lifecycle Toolkit by Ralph Kimball et al....

Not sure I'm following completely.

You have a single name column in your source table, and you have a 'shortname' column as well as a 'legalname' column in your destination?

Are you...

Based on your requirement:

...check iSValid Value and if it's "0" then "0" Else Increment by 1 starting with 1 for the whole set until the next IsValue = 0

I think...

Must this run from a service? Can you schedule as a job? If you're using some sort of trigger/logic in your service to fire the execution of the...

You can use a Derived Column task in your data flow to replace "" with whatever you wish. You may need to do a Data Conversion on that column...

You will likely need to build your SQL Statement in a variable using expression language.

If you use expression language to create your sql statement you can manipulate the dates for...

Libby,

In your Execute SQL Task; do you have your object variable listed in the Result Set section assigned to Result Name 0?

When you output a SQL task to a variable...

I agree that it executes them synchronously, but the cursor will run through all of the rows rather than pausing between rows for completion which makes monitoring the cursor a...

Thanks all for the help. They both run in the exact same time, 1 minute 4 seconds, and return ~76,000 records.