February 20, 2008 at 8:13 pm
I have the task to FTP backup files and transaction files from one server to another, but I need step by step of how to get this accomplished using SSIS as I have never used it but I think that SSIS can do this. Please I need help from anyone out there that can help. Thanks in advance and God's blessing.
February 21, 2008 at 7:49 am
Basically you have to use FTP task transformation mainly, plus a file system task to pull the .bak files to the FTP site. That's all.
1. If you know how to start a package, go ahead and do it and then
drag and drop File System task and point that to your folder where
you keep your backups
2. Drag and drop FTP task into your design pane. (Note that you will
need login and password for the FTP) Pull the green Arrow(precedent
constraint) to the FTP task from File System Task
3. Then fill in the property for FTP task and set it to send files.
That's all. Should not be a problem. Give it a try! 😉
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
February 21, 2008 at 8:36 pm
Thanks I will try it and let you know. regards
February 22, 2008 at 5:55 am
Is this just for SQL Server 2005 or can it be done on SQL Server 2000?
If so, by "Open package" do you mean a DTS package?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply