A ForEach task performs a "data copy" from SQL DB to .txt file and with sftp service writes the files to a folder on the server. This is done 10 times. The files are all named differently. A connection to the server is opened and closed for each file. Is there any way to open the connection once and make the copy of the 10 (or more files) and then close it only at the end?
0 Answers
Related