I have data in sql server database called 'Test'. Using set of queries on 'Test' database, I have to create and load data into CSV and Excel files where frequency of generation of some files is 15 days and some has daily. And finally I have to push some files to FTP, Some files to SFTP and other files to EMAIL. Could you please help me How do achieve using SSIS as I am new to SSIS?
Agreed with the Nidheesh, break the problem in the small tasks. 1) - To generate the file: To fetch the data from the SQL and write them in the CSV, this you can do using DATA FLOW TASK; Source is SQL and destination you can use Flat File Connection manager and while configuring the connection, choose as DELIMITED and mention comma (,) in delimiter. For EXCEL use EXCEL destination. 2) Use Foreach loop container and configure it according to the requirement and use FTP task to share the files at FTP location. 3) Use Foreach loop container and configure it according to the requirement and use send mail task to share the files via MAIL.