Hello:

does anyone know if the 'Copy SQL Server Objects task' is transactional?
I mean, if i´m copying many tables data from one database to another, if the
copy fails, the whole copied data will be removed?

Thanks for any comments on this.

--
JPortelaS.
..Net developer

Jportelas wrote:


In SSIS I tried using transactionsupport type to required and it gives
error
[Transfer SQL Server Objects Task] Error: This task can not participate
in a transaction.

Also when I stopped it in middle , but does not rollback copied
objects.

Accoding to BOL

All Microsoft SQL Server 2005 Integration Services (SSIS) container
types-packages, the For Loop, Foreach Loop, and Sequence containers,
and the task hosts that encapsulate each task-can be configured to
use transactions.

It does not state anything for Transfer SQL Server Objects Task, So I
feels that this task can not be part of transaction.

if it does not support it 2005 , it must not support it in 2000.

Regards
Amish Shah

Thanks for the reply amish.
So no transactional support in 2000 (which is my case).
bye.
--
JPortelaS.
..Net developer