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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to Send Single MS SQL 2008 R2 Table

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!
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -