0

In SSIS, how to copy files ( Loop through Folder) from one directory to another using Task Factory Pragmatic Works?

svick
  • 236,525
  • 50
  • 385
  • 514
Litaney
  • 5
  • 3
  • you dont need any component from TF, read http://stackoverflow.com/questions/39626457/ssis-openrowset-query-flat-file/39646773#39646773 – Ricardo C Sep 29 '16 at 17:35
  • I have to use a Task Factory Component. It's not an option – Litaney Sep 30 '16 at 13:38
  • is not an option? is your Visual Studio broken? TF are **additional** components, they don't replace the already existing components in Visual Studio. There are so many other reasons why your statement makes no sense to me, you may want to explain it, maybe others may help. – Ricardo C Sep 30 '16 at 16:39
  • By Company policy, I have to use secure FTP to copy files over – Litaney Oct 17 '16 at 13:24
  • SSIS supports SFTP out of the box – Ricardo C Oct 17 '16 at 17:06
  • I thought SSIS only has FTP Task Component. Could you explain little more on how SSIS suports SFTP out of the Box – Litaney Oct 18 '16 at 14:37
  • I was mistaken. SFTP is not. – Ricardo C Oct 19 '16 at 17:07

0 Answers0