Execute SSIS package from ASP.NET

Execute SSIS package from ASP.NET web forms. Let’s take a scenario, we will create a table in SQL server and insert data into that table using SSIS package and call the package from Web forms. Step 1 Create a table in SQL server named “stud”. Step 2 Prepare a parameterize insert SQL query. Step 3 Create a SSIS package. Open SQL Server...

Continue reading

Export to excel in ZIP format

Problem Exporting large file from Asp.Net pages cause huge bandwidth consumption, slow response and time-out problem. In most of application there are couple of pages where we export large data file in to excel. And the most common problems are response time-out and  slow UI response. Solution There are two solutions for this problem. Enable...

Continue reading

SSIS – connection string from XML

SSIS – getting connection string from XML file. Step 1 Go to SSIS and select Package Configurations.  Step 2 Add new configuration. Step 3 Select Configuration type as XML Configuration file. Then select Specify configuration setting directly radio button and select the configuration file. Step 4 Select the property which you want to...

Continue reading

Asynchronous Delegates

As the title the asynchronous delegate refer to invoke a function in async manner. The declaration is same as normal delegate. public delegate void mydelegate(string s); Next thing we need a method to assign it in delegate invocation list. So I create a method named Function and sleep this method for 5 second to give an effect that this...

Continue reading

Anonymous Delegates

Anonymous delegates are the delegate where an anonymous method is embedded to its invocation list. Anonymous method do not have name, they have only code block called body. Three things involved in this process. 1. Delegate declaration public delegate void mydelegate(); 2. Create and object of this delegate and assign the anonymous method in...

Continue reading