Hello, I am trying to set up flat file connection manager to FTP Site, my purpose is to be able to streamline the column and have it read to transfer those data to the database. I do not want the file on the local machine, it should be coming from FTP server. Is there any way to do this? Thanks.

The Flat File connection manager does not support FTP. You must first downlaod the file, and then use the Flat File connection manager. You may not want the file local, but you don't have a lot of choice if you are trying to use the Flat File connection manager. There are some third-party products that can make a FTP site appear as a local drive, nothing to do with SSI, but they would work. They of course do download the file, just behind the scenes.http://www.sqlis.com | http://www.konesans.com

Map the FTP Drive to your local machine and then configure the connection If you want to make the mapping temporary then us can use a Process Task Set it up as follows 1) In the Process Tab set Executable to cmd.exe 2) Set Arguments to /c net use m: "\\Servername\folder" (Maps to drive M ) To drop the mapping use another Process task Again use the Process Task and change the arguments to /c net use m: /d drops drive M You can create a flat file connection to the mapped drive Hope this helps Regards, Sandeep