Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malawneh
Starting Member
24 Posts |
 Posted - 2008-04-14 : 15:39:42
|
| Here is what I am trying to accomplish. I need to move *.pdf files from a local directory into a local staging directory, then from the Staging directory FTP them up to the customers site. Then move the files from the staging directory to an archive directory. I can do this fine as long as all values are static in SSIS, I need help to figure out hoe to do this using variables. The Directories to be used are to be supplied by the DB all that is give in the directory itself all files in the directory need to be moved. Any help would be appreciated.Thank you,MikeMichael Alawneh, DBA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-15 : 12:06:42
|
| Declare you variables in varaiable tab. Populate the variables with your values from db using sql command task. Then map these varaibles to appropriate properties of your tasks in dynamic properties tab. |
 |
|
|
|
|
|
Move file from variable locations.