Excel data to data table using Aspos

http://www.aspose.com/docs/display/cellsnet/Exporting+Data+from+Worksheets

using Aspose.Words;

using Aspose.Cells;

using Aspose.Cells.Charts;

using Aspose.Cells.Tables;

No Object Exist with Lineage ID of XXXX in SSIS

Please click below link
1) when you migrate your SSIS package to SQL higher version
2) place square brackets around column name in SUBSTRING function

see below link

click here



done.

Simple C# code to get Quarters

 public static DateTime GetQuarterStartDate()  
     {  
       DateTime date = DateTime.Today;  
       int quarterNumber = ((date.Month - 1) / 3) + 1;  
       return new DateTime(date.Year, (quarterNumber - 1) * 3 + 1, 1);  
     }  

empty toolbox in ssis, there are no usable controls in this group.

1) If you open Integration Service Project solution and you can see below

2) right click on your package and select SSIS toolbox

 

thanks

svchost.exe process consume CPU memory with "winrscmde" description

If  you feel your computer is very slow.  Some time you get BLUE screen in your Windows 7 OS.
Please check following things:
1) hit Ctrl + Shift + Esc to open task manager.
2) Click "Processes" tab.
3) Sort by "Memory" > higher memory first
4) check if any services running with "svchost.exe" image & "winrscmde" as description
and conusming lots of CPU memory.


Solution:

download TDSKiller.exe from CNET > Install & Scan your computer


http://download.cnet.com/Kaspersky-TDSSKiller/3000-2239_4-75722087.html 


More details:

http://www.bleepingcomputer.com/forums/topic436219.html
http://forums.spybot.info/showthread.php?t=66455




thx

select column in PDF, Vertical test select in pdf

hold Alt key and then select PDF column it will select vertical.

Cannot add an entity with a key that is already in use, LINQ

-- When you get above error there are two possibility

1) you are trying to insert duplicate primary key.
2) when you have SQL column with data type = "Uniqueidentifier" and default set to 'NewID()'
    that means its auto-generated field.

   Make sure in you DBML file that tale > field > properties > "Auto Generated Value"  is set to true
   default is fault