SSIS FTP Error
hi
my package running file. downloading file, import in database , processes.
problem occures when there no file on ftp ssis failed , give me message "an error occurred in requested ftp operation. detailed error description: connection server not established . end error error: 2014-09-12 02:30:41.29 code: 0xc002918f "
regards
shahid
you can use script task before looping task , check if ftp folder has files. based on can set value boolean variable 9say @[user::fileexists]) link script task loop using expression based precedence constraint ie use option expression , constraint, set constraint onsuccess , expression as
@fileexists == true
and not throw error.
please mark answer if helps solve issue visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/vmblogs
SQL Server > SQL Server Integration Services
Comments
Post a Comment