That's why I talked about redirecting or ignoring the error output of...

yingchai (4/13/2010)

---

Hi da-zero,

If I have more than one transformation for EntityID column, how is the expression looks like?

COMPANY | ENTITYID

---------------------

AAA | BBB

CCC ...

dbowlin (4/13/2010)

---

You can also create another package in SSIS and add an Execute Package task for each of your other packages, and then simply put a success precedence constraint between...

Add a derived column transformation with the following expression:

(ISNULL(myColumn)) ? 0 : myColumn

Do this for every column that needs conversion.

Add a Derived Column Transformation to your data flow.

Select "Replace 'EntityID'" in the Derived Column.

Then use the following expression:

(EntityID == "AAA") ? "BBB" : EntityID

This will replace all AAA values...

Open the package with a text editor.

You will see the XML code of the package and somewhere in all that gibberisch, there should be your VB/C#.NET code.

I believe it is best that you only make changes to packages in the test environment and then deploy them to production. Making changes to production packages is asking for...

You could use Cognos Analysis Studio, but I'm not really aware of the cost that comes with it.

(because you should also have Cognos Framework Manager and Cognos Connection).

It is web-based...

The simplest way to know of an entire row has been updated, inserted or deleted is by using a creation_datetime column and a delete_indicator (or a current_indicator, whatever works for...

Another alternative (my brain takes some time to warm up :-D) is to set the value of the table I spoke of at the end of the package. Keep a...

You could execute your packages in a SQL Server job.

For each jobstep, you can specify what to do with success and failure. Point to a specific jobstep that updates a...

No, the precedence constraint 'On Completion' means that...

You're absolutely right, forgot about that one 😀

A small question:

isn't the variable @InputStr stored somewhere? As the loop goes on forever, at some point in time that variable will become too large to reside in memory/physical location....

What are you exactly trying to find out, because as far as I know, there aren't any execution plans for SSIS.

There is the concept of execution trees though, is that...