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!!
