How to move multiple files with a File System Task
-
Hi,
I looked at the video of File System task.
I know how to copy 1 single file from 1 directory to another.
I cannot find how it works with multiple files.
My goal is the following:
- Create a backup (DB or log) of multiple databases locally on SQL server
- Immediately after this backup I would like to copy away these backup files to another server.
Package can consist of 2 steps:
Step1: backup
Step2 : File system task
Thanks
Hans Peeters
-
Use a ForEach loop container to loop through all of the files in the directory and put the file system task in the loop.
-
Have you tried using wildcards (*, ? ) ? You cannot specify them in the File Connection manager dialog. Right-click on your connection manager and select Properties. And then change it from there.
Let us know how it goes.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Or Even a scritp task to copy from one directory to another.
Ells.
🙂
-
Hans Peeters (12/9/2008)
Hi,I looked at the video of File System task.
I know how to copy 1 single file from 1 directory to another.
I cannot find how it works with multiple files.
My goal is the following:
- Create a backup (DB or log) of multiple databases locally on SQL server
- Immediately after this backup I would like to copy away these backup files to another server.
Package can consist of 2 steps:
Step1: backup
Step2 : File system task
Thanks
Hans Peeters
you want T-SQL / .NET Code for this task ?
-
CozyRoc,
Not working.
You get a package validation error after excecution.
"Error at File System Task: Type of connection "Work directory" is not a file
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply