tsql - SSIS: sql statement as parameter -

i have button on site, user clicks export data excel file. problem facing data gets large (40+ mb) , web throws time out error.

the web takes parameter dropdown box, , pass stored procedure.

my solution dump data on excel file on network drive instead of returning directly user. user notified, via msdb.dbo.sp_send_dbmail, once file ready.

i found articles on internet showing how pass parameter stored procedure within ssis, not how pass whole sql statement ssis.

i'm new ssis , appreciate detail example.

thank you!

i not familiar web, i'm not interested making change web @ moment.

with executesql task can put sql statement in variable, or separate file.

in sql task, set sqlsourcetype either variable or file connection.

then sqlstatement set appropriate variable or file connection.