Thank you for clarification.

Additional I have below doubts

1. Currently I am loading the csv files using T-SQL, But for some records there are disproportionate delimiters.

   Eg: In a Comma separated file...

The best solution for Jobs

In every Job add a step-1 where it checks for the primary of the Availability...

Let me know once you install SSIS successfully following the instructions.

Yes sir you have will have more manual work for now but once set up the jobs on both the nodes you can enable a step to check if it...

you may be missing installation of Integration Services properly

That can be done. But you have to put your packages in SSISDB and that needs to be in as a AG database. Also I think the databases should be...

Have you guys resolved the problem yet.

You have to take the packages first and pull it on BIDS, this will convert them into project deployment model. When once your new 2012 server is ready you can...

Very Informative in naive language.

http://download.microsoft.com/download/9/5/3/9533501a-6f3e-4d03-a6a3-359af6a79877/sql_server_2012_upgrade_technical_reference_guide_white_paper.pdf

I think you can take a copy of those packages and then work on the SQL Server Data Tools. That's how I worked on packages.

How about setting up log shipping and run the scripts for the backup and restore of the last T-Log in the time of cut-over.

check this

http://www.sqlservercentral.com/Forums/Topic1001329-391-1.aspx

Please look into this

http://www.mssqltips.com/sqlservertip/2454/how-to-find-out-how-much-cpu-a-sql-server-process-is-really-using/

Check this it might help you (step2 and step 3)

http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

Check this.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a6fd7f30-cabd-4cda-a117-ad9a862ea5a6/sqlservrexe-is-continually-eating-more-memory?forum=sqldatabaseengine