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

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...

opc.three (5/15/2012)

---

The staging table to which I am referring is a new table you will create in the destination database. It's sole purpose will be...

Staging table means destination table?

if yes, we cant able to clear the staging table, its accessing 24/7

I'm using SQL 2005 so its not possible to using merge query on single...

Sorry to say that i did not understand your point.

can you explain once again briefly.

pradeep.mohan (5/14/2012)

---

So i can use like this in BIDS :

In Control Tab: Execute SQL Task (Insert)

...

So i can use like this in BIDS :

In Control Tab: Execute SQL Task (Insert)

...

Hi Friend,

source table is keep on growing (day by day) so we cant judge the number of rows.

We cant able to drop or truncate the destination table also because the...

Hi Guys,

I am new is ssis.... i want to data populate from source DB to destination DB (insert / update / delete) how can i achieve this...

Is it need to...