Loading

Create and load the files and send those files

Mannu k

10y1k

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar Singh10y ago
Database to CSV File

https://support.spatialkey.com/export-data-from-database-to-csv-file/

CSV to FTP

https://www.mssqltips.com/sqlservertip/2884/sql-server-integration-services-ssis-ftp-task-for-data-exchange/
0