February 6, 2009 at 8:18 am
I am REALLY new at using SQL and have been trying to find a way, the best way, to FTP the results of a query within a stored procedure. The query is over multiple tables and the results will always be under 100 records.
We're using SQL Server 2005 and Visual Studio 2005 v8 and any help or advice will be appreciated.
February 9, 2009 at 9:10 am
The way i see is there are couple of steps involved in this.
1) Creation of the file which contains the information (i.e 100 records based on multiple joins).
-- To do this you need to write the results to a file. Check out the below link
2) Now FTP this file to the server.
-- You can do it in simple T-SQL Stored procedure. Check out the below link
http://www.nigelrivett.net/FTP/s_ftp_PutFile.html
Thanks -- Vijaya Kadiyala
February 9, 2009 at 9:15 am
Alternatively you could use SSIS for this taks, you can put your procedure in the data source and send the data to a FTP destination.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply