Hi Daniel ,
You have wrote excellent artical and very useful.but I am getting Below error when i am exporting images from databse. in my development sever has images folder is there in C Drive
[Export Column ] Error: Opening the file "C:\images\" for writing failed. The path cannot be found.
[Export Column ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Export Column" failed because error code 0xC02090A0 occurred, and the error row disposition on "Export Column.Inputs[Export Column Input].Columns[Path]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Export Column" (2) failed with error code 0xC0209029 while processing input "Export Column Input" (3). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
But I have images folder in C drive.i dont no what i have to do. can you please le me know