InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:47:52 GMT20http://www.sqlservercentral.com/Forums/Topic1407095-145-1.aspxAs detailed, create a file share on Server1, ensure that the nessesary permissions are set on the file share, then use a UNC path to access the server like the below in your flat file connection manager.\\Server1\ShareName\FlatFile.txtIf you have multple flat files to import use a for each loop, passing in the file name as a variable and using an expression to the flat file connection manager so that the path changes dynamically with each file read from the share.Tue, 15 Jan 2013 02:23:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407095-145-1.aspxyes but this transfer is using ssis and processed to database directly.Tue, 15 Jan 2013 02:20:14 GMToneonesiphttp://www.sqlservercentral.com/Forums/Topic1407095-145-1.aspxWhat are you trying to do?Import flat files from Server1 into a database on Server2?If so ensure that you have setup the correct file shares, use UNC paths in your SSIS package and ensure that the nessesary security has been applied to the share so that the SQL Agent or the proxy account used to run the SSIS package has access.Tue, 15 Jan 2013 02:17:12 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407095-145-1.aspxI have a problem to call file from another server with dtsx, any one know this?Tue, 15 Jan 2013 02:09:33 GMToneonesip