Hi,

SSIS doesn't provides an easy to use interface for a simple dimension
update.
have you any workaround?

In my staging database I allready know which rows are new and which rows
need an update.
The new is simple, I insert, so the mapping is easy and automatically
generated by SSIS.

but an update statement no.
instead-of displaying a user friendly column name, SSIS display Param_1,
Param_2 etc...
so any error in the mapping and I invert the first name and last name of my
employee...

also, this method disallow a good metadata tracking, I can't know which
column update my destination column.

any idea of how to create this mapping more easely, quickly and securely :-)

Does I have to create my own destination object? if yes, any sample
anywhere?
any other idea?

thanks.

Jerome.

my English not good,so sorry,HOHO
I had a same problerm. now,I know tow ways to resolve it.
1 use OLE DB Command Transformation
2 use Execute T-Sql Statement Task

Jéjé wrote:

I'm using the second option.

"wangh" <wangh.98 (AT) gmail (DOT) com> wrote

my English not good,so sorry,HOHO
I had a same problerm. now,I know tow ways to resolve it.
1 use OLE DB Command Transformation
2 use Execute T-Sql Statement Task

Jéjé wrote: