Although the answer is mentioned directly in the error message, you can also find it here:

http://www.sqlservercentral.com/Forums/Topic941566-148-1.aspx

I'm glad to help!

Robert Biddle (6/22/2010)

---

I have a Script Task in SSIS 2005. I want this task to log any errors that may occur but I do not want to fail the task.

My...

tmitchelar (6/21/2010)

---

vineet1234 (6/18/2010)

---

5) This way we get the non-matching rows in the error out put. These are the new records coming in.

Among the matching rows we can use a Conditional...

This is not the fault of SSIS. The completion precedence constraint checks the completion of the task (whether this is a SQL Server Agent task or another one). The task...

You just can't compare two values if there are possible null values. You can compare null with "unknown", so your expression will fail sometimes.

So, either clean-up your input with isnull,...

You should set-up a configuration file or config table for each environment.

Then point to this config file/table with an environment variable (this has its advantages and disadvantages, but I'm not...

I believe you forgot the table name in your query.

Personally, I think it is easier to store the SQL statement in a variable and then configure this variable with an...

You use these three things to configure a connection dynamically in your package.

Merge component: http://msdn.microsoft.com/en-us/library/ms141703.aspx

Merge Join component: http://msdn.microsoft.com/en-us/library/ms141775.aspx

I'm sure you can come up with an example yourself.

Computers are dumb things. They do only exactly what you tell them to do, and nothing more.

You gave an expression, so SSIS evaluated it and stored it in the config...

I can answer this question. The advantages are that you can use built-in features of...

You don't have to open a new integration services project.

The Import wizard makes a SSIS package for you. Find this package (the wizard asks you if you want to save...

Good question.

Lose one point but learn a useful fact. A good trade-off 😀

I couldn't agree more.

Sometimes the analyst gives me some unformatted SQL code generated by a Build Query editor in SSIS.

The first thing I do is format the whole thing. While...