@ James Connor.
Thanks for the input. I too have solved the same issue by replacing " SQL Server Destination " with " OLE DB Destination ".
This behaviour has been explained well @ http://consultingblogs.emc.com/jamiethomson/archive/2006/08/14/4344.aspx"> http://consultingblogs.emc.com/jamiethomson/archive/2006/08/14/4344.aspx
In 'Dead' Memories,
[font="Comic Sans MS"]Vampire[/font]
--In 'thoughts'...
Lonely Rogue