Another thing you need to notice how you want to cater the already present record which are there on your destination table but got modified in the Oracle source, if...

Hi,

You can do this using scripting in vb or C# in SSIS script task. There is a beautiful post on this requirement.

http://sqlserversolutions.blogspot.com/2009/01/creating-directory-using-ssis.html

Thanks

Varun