Copy and Paste Excel file
Can SSIS 2005 allow me to take a copy of an Excel file and paste it into a different location?
if so, how?
Thank
May 29th, 2012 4:53am
Use FileSystemTask to do the file operations.
Example to use filesystemtask:
http://sqlserversolutions.blogspot.com/2009/04/copyrename-file-using-file-system-task.html
Thanks,
Saikat
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2012 5:05am
Yes you can copy or move a file from one location to other using SSIS. You can do that by using File system task .
May 29th, 2012 5:05am