Parallel processing in SSIS package

few Days back i posted about SSIS package . as per our discussion with our architect we have decided to to go with SSIS package.

when developing a small application with SSIS i noticed if we have multiple Tasks coming from single TASK then all those execute in parallel and if i am not wrong that is parallel processing in SSIS package by default.

The task which has many connecting lines coming to it waits for all tasks to finish their execution.

When those tasks are executing in parallel in SSIS package if any of task fail the we can have seprate exception handling for that particular task.

so i guess we have parallel processing of task by default in SSIS package .

Please let me know you suggestions .

Uploading file directly to database using mvc

hey friends back again with MVC .

we have a portal where use can upload a file and from that file MVC application will get data and 
currently we have a requirement where we have to Upload the file that will be in .xls excel format.
we implemented it Upload the file and save it on server then from that location we can read it in byte stream and save into database.

but the problem is our architect is not giving the write permission on server :(:(
 so do we have any solution where we can directly save the content to database and read it from there .

if yes please update in comments.

Found one link

http://forums.asp.net/t/1808216.aspx/1?Help+On+File+Upload+to+database+in+MVC

i have not yet tested it hope it works .

Do's and Dont's for WCF service

Most of who are reading this blog has faced the problem of how we can increase the performance of WCF service. someday we all are goin to face the requirement we will have huge no of user who will be trying to consume WCF service.

we always start on performance after completing the development of WCF service. but there are some points which we should remember to have hige performance WCF service.

below are some points which can help you in increasing the performance of WCF service :

• choose carefully between singleton instance and per call instance.
• if you have like 100 users hitting your wcf service simultaneously use per call instance as this will give you best result.
• problem with singleton instance is with concurrency. we faced this issue in one of our wcf service.
• response time decreased from 120 ms to 80ms :O  wooow
• use tracing to find out which method is taking maximum time and try to minimize that.
• Make sure to use web service throttling. you can find a lot of articles on web service throttling, but in my case it didn't work as expected though it is very useful.
• try to minimize the database hits . use caching to get configuration . surely this is going the increase wcf service's performance a lot.
• if you are using logging or trying to log the request and response message do it in a sync way.
• always free the objects as soon those are not required .

And Before completing the development of WCF service try to take a  what can be done to improve the performance of WCF service.

SSIS Package

Recently we got a requirement of  saving data from one server to another server . both server has SQL server 2012 . data will not be not that huge but we are expecting 10-12k records everyday.

This data will be transferred once in a day.

so after looking other options like creating a job in C# and sending data in xml as extarct or using big data and SSIS we have finalized SSIS . I am very new to SSIS dont know much about SSIS .

so i just started working with SSIS package so whatever will be the questions or learnings i will be posting.

meanwhile i would like to whether its a correct decision to use SSIS in this scenario ??

Improving WCF service performance

we discussed about how to improve the WCF service after a lot of research we found that in our service we have around
1) 10-12 database calls
2) 2 service calls.

so it was taking around 300ms. :O
 huuuuuhhh

after implementing webservice throttling and what we say having instance per call we are still not able to to get the desired result.

currently we are planning to convert those 10-12 db hit into single db call and are plnning to to call other service in async way .

any other help will be greatly appreciated .