How to insert/update/delete into destination table

Question

Post reply

How to insert/update/delete into destination table

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

pradeep.mohan SSCrazy Points: 2849 More actions · Answer 1

I build a DTS package like this (OLE DB Source --> Multicast -->OLE DB Commend)

In my package source table and destination table datatype is different.

So is it possible to transfer the data from Source to Destination?

Because i am getting validation warning error when running a package.

Thanks.

Pradeep

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 2

pradeep.mohan (5/22/2012)
In my package source table and destination table datatype is different.
So is it possible to transfer the data from Source to Destination?

Yes. Look into using the Data Conversion transformation in your Data Flow.

Data Conversion Transformation

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

pradeep.mohan SSCrazy Points: 2849 More actions · Answer 3

you mean 'Data conversion' component using next to multicast (OLE DB Source --> Multicast --> Data Conversion --> OLE DB Commend)

Pradeep

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

pradeep.mohan (5/22/2012)
you mean 'Data conversion' component using next to multicast (OLE DB Source --> Multicast --> Data Conversion --> OLE DB Commend)

It will depend on the destinations. If all destinations are the same then you can use it before the Multicast. If all destinations are different then you will need to use it after Multicast.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato