Institute. That explains a lot. 😉

(how come this thread is already 5 pages long and yet contains so little value?)

Alvin Ramard (10/22/2010)

What do you mean by: "extract the package"?

I can't help but wonder what the client...

Nice question, learned something.

Nice and easy. Thanks.

No. Powerdesigner is more a data modeling tool for databases. You can document ETL (and thus generate mapping information), but it can certainly not read SSIS packages or replace them....

Well, it can be done in Powerdesigner, but not that easily.

(and Powerdesigner isn't actually a documenting tool).

I'm going to work with Powerdesigner in the following days, I'll let you know...

Well, that's why I added "normally".

If you really can't get rid of those final characters (because apparently some "inverse-thief" puts them there), you can always try to put some bogus data in there and then...

Normally the mapping of an ETL flow is some sort of matrix where you "map" the input columns with the output columns.

E.g.: Input_Street + Input_StreetNumber = Output_Address

Great, it seems that you are getting there 😀

I never use the == TRUE(/FALSE) with the ISNULL function. There is not really a point comparing a boolean value with another boolean value, so I just take the original...

I guess SSIS does some validation first before it starts running and that this validation fails. You can see in the output window in what stadium the package threw an...

This is the expression from Steve in "derived column language" (aka put everything on one stupid line language):

(ISNULL(effDt) || LEN(TRIM(effDt)) < 8) ? NULL(DT_DATE) : (DT_DATE)(SUBSTRING(effDt,5,2) + "/" + SUBSTRING(effDt,7,2)...

Check if the record also exist in your dsv, not just in your database. Use the queries that you use in your dsv to locate the record. Also make sure...

I used the following book to get up to speed with VB.NET:

Programming Visual Basic 2008 by Tim Patrick, published by O'Reilly.

You don't need to read every chapter in the book...