Re: SSIS OLE DB Destination and variables

#1

Hello DSB,

Using the variable create a derived column (use the Derived Column transform)
before you hit the destination

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

I am redirecting error rows to a table using an OLE DB Destination. I
need to be able to insert a value from a local package variable to one
of the columns in my destination table but have been unable to find a
way to do this in the 'Mappings' tab. Any advice?

btw, I'm using the 'Table or view - fast load' Data access mode. Do I
need to use a SQL command with variables?

#2

Hello Todd,

You wouldn't. if the destination table is always always t1 then t1 it is.

That was not the drift of my post though. using a variable you can "derive"
a column and a value in that column in your pipeline. In DTS you would do
all kinds of wild and whacky stuff on the actual mappings screen but not
this amppings section of the destination adapter is just that, mappings.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

In order to re-direct rows from a Destination connection to an error
flow, I have had problems using the 'Fast Load' so I use a regular
Table or View. If the destination table is not going to change, then
why would you need a Variable?

"Allan Mitchell" wrote:

Hello DSB,

Using the variable create a derived column (use the Derived Column
transform) before you hit the destination

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
I am redirecting error rows to a table using an OLE DB Destination.
I need to be able to insert a value from a local package variable to
one of the columns in my destination table but have been unable to
find a way to do this in the 'Mappings' tab. Any advice?

btw, I'm using the 'Table or view - fast load' Data access mode. Do
I need to use a SQL command with variables?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SSIS OLE DB Destination and variables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SSIS OLE DB Destination and variables - 12-12-2006 , 03:42 PM

Re: SSIS OLE DB Destination and variables - 12-13-2006 , 03:31 PM