I want to execute a external asp.net page from ssis.But from ssis i need the data for operations in the aspx page.

Execute Process Task http://msdn.microsoft.com/en-us/library/ms141166.aspx

Executing an external website is also possible with a Script Task and some .net code. Something like: string website = "http://microsoft.com"; //or get it from a ssis variable System.Diagnostics.Process.Start("iexplore.exe",website); or without i.e.: System.Diagnostics.Process.Start("http://microsoft.com"); But what do you mean by "But from ssis i need the data for operations in the aspx page"? Do you want to pass data from SSIS to that website (You could do that in the querystring) or do you want to get data from that website to SSIS? In that last case you should consider a webservice instead of a website.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com