You are testing with a very specific record, as Evil Kraig suggested, add a data viewer, plus add one condition at a time to the filter, I will start with...

No worries mate, take your time, it will be interesting to find out the outcome of my suggestion!

Cheers,

Hi mleehayes

Sorry for the late reply, it took me a while to digest the information found; let's review it:

From the following MSDN article: Behavior Changes to Integration Services Features in...

It does work, but you are creating extra dependencies in your solution, it might seem nice today, while it could become a maintenance monster in the future.

Hi cooperkuo

It will best for you to get a copy of the following book: Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

The book is excellent, full of examples including...

Duplicated post, answer given here

You can't convert string (varchar) columns to numeric (int), your options are:

a. introduce a numeric (int) column in your target table, or

b. exclude the ID column from your transformation,...

Hi mleehayes

Based on your description, are your production packages using a SSIS Configurations table located on a Development Database hosted by a Development Server?

If that is the case, your SSIS...

The Conditional Split will do the job, you could add a condition named known exceptions with its condition like SUBSTRING(UPC,1,4) == "4000" && QtyOnHand < 20

Cheers,

Wow, the password is not there, it is nice to know 🙂

Hi MVS2k11

Your condition looks good to me, please follow these steps to add a conditional split to your solution:

1. Add the Conditional Split transform to your solution, and connect it...

Thanks CafeScott for sharing your solution, you are using an Script Task to setup the FTP Connection Manager 'dynamic' properties, you can set them directly in the Connection Manager's Expressions;...

Hi Mohammed Yousuf

Have you tried the CommandTimeOut? I am not sure is you want to setup the timeout from a Net client application, I believe you do based on this...

Hi MVS2k11

You don't have CASE statement, you should use in-line IF, your condition is equivalent to

ISNULL(ted) ? 0 : (ted = "Yes" ? 1 : 0 )

Cheers,

This is a duplicated post, the issue was resolved here