I want to save the Excel Export underneath an intranet hyperlink ? What would be the best way to do that .Right now, i am trying the regular excel file path option and placing the http link in there. I am getting an error message on execution. Thanks

Can you elaborate on what you mean by "underneath an intranet hyperlink?" There is no built-in support in SSIS for saving files to HTTP locations, so understanding your goals might help come up with more options.

I mean , can the file in xls format be saved under a hypertext link like http://ctseroom03.corp.emc.com/eRoom/csgts/EMCGTSOperations/0_a290e? I have createda folder under the above link where the file needs to be exported to .

You can export the Excel file to a file share on the web server that is exposed on a web site. However, you can't upload a file to an HTTP web server without using the Script Task. You can FTP a file, but that might not meet your needs.

Hi, please follow the below link , I hope it will help you http://www.dotnetcodes.com/dotnetcodes/code/Source-Codes-13-Creating-Excel-file-in-C.aspx