Oh yeah, forgot to mention:

if you have SQL Server 2008, just use the MERGE statement, much much easier :-D.

If you have 2005 and you're allowed to use 3rd party components,...

Certainly don't use the OLE DB Command for the updates, as it will issue one million transactions against your DB if you have one million updates.

This is the approach that...

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 😀