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 |
ladowali
Starting Member
16 Posts |
Posted - 2014-04-21 : 08:18:54
|
Hi Group,I need to send one sql table to my remote office on regular basis. Can some one suggest a simple way to do this. I have a ftp server but don't know how to do the one table.Thanks |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-21 : 08:34:28
|
In SSIS, set up a connection (call it input) to your table. Then. set up a second connection (call it output) to your FTP server. Connect the two. Done! |
|
|
ladowali
Starting Member
16 Posts |
Posted - 2014-04-21 : 08:43:51
|
Hi gbritton,Could you please clarify little more. What menu option are available for this setup?Thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-21 : 09:45:56
|
In the Data Flow Tab, under Connection Managers, right-click on an empty space. Select "New Connection". For FTP, scroll down to FTP and select that then fill in the parameters. For your DB, select OLEDB and fill in those parameters. When those are ready, add a Source and point to your OLEDB connection and select the table you want. THen add a Destination and choose the FTP connection. Connect the two by dragging the arrow from the source to the destination. That's about it. |
|
|
|
|
|