MSSQL Select commands to FTP

Hello,

Im new to Sql Server Integration Services.

I need to get the data I get from my SQL Select statement into TXT, XML, CSV or Excel file format and then send it with FTP.

What is the easiest method that you recommend that I use?

Thank you very much!!

Data flow to select your records using an OLE DB source. Send those records to a text file (or csv) using the flat file destination.

Then in the control flow, use the FTP task to send that file.|||

Thank you very much for the reply.

I know this sounds simple, but do you know any tutorial out there that shows how to do this?

Thanks again in advance.

|||Try looking through the SSIS tutorials. What you need is pretty basic stuff.

http://msdn2.microsoft.com/en-us/library/ms167031.aspx|||

Thank you so much.

I have one complexity though.

My SSIS flow is gonna be run every day as a sceduled task.

The first time it runs, it has to send a History (Select Statement 1) but every day after that it just has to get the latest info (Select Statement 2).

How do I do this?

Thank you very much in advance!!