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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2011-12-01 : 03:54:13
|
| Hi,Is it possible to change between the FTP connection to File connection based on a configuration variable value so that the package should support copy of files from either a FTP Folder or a normal Folder and put it in a local folder in the server.Thanks in advance.- Varalakshmi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-01 : 05:20:37
|
| nope. not using same task. However, what you can do instead is to add two tasks one for ftp and other for file transfer using file system task. and then execute either of them based on a condition specified using constraint and expression option in precedence constraint.If you explain more on scenario, we will be able to provide much detailed info------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-12-01 : 06:10:29
|
| Another option is to use a script task.Do you have to use SSIS?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Copy files from FTP path to Local folder