I have files(images and videos) located on my intranet. My intranet has a user name and password.. I have a FTP connection manager in SSIS(2008) where i provide all the credentials.. server, port, username and password.. I would like to read the file name from a table in SQL Server 2008.. The file name is something like sofa and add a .jpg to the end of it, then check to see if that (sofa.jpg) exists in a folder, if it DOES NOT then I want to ftp the sofa.jpg from the intranet to the folder in which it does not exists.. recomendations? Please do not suggest script task(VB or C) because I dont know it.. If I can avoid the script task I would like to.