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

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607