In DTS 2000 there was situation where I had to connect source and destination through a dialup connection (56k), where the transferring of data took me ages to finish, so it was not successful.
In SSIS 2005 is there is a solution?
Thank you
Cheers,
Pradeep.
You can use a multicast component, immediately after your source adapter.
One output from the multicast should go through your usual transformations to the destination.
The other output should go to a Raw File destination. The Raw File destination is not transactional, so it will capture the records it received and will not roll them back even if there is a failure.
Donald
No comments:
Post a Comment