project is compatible to visual studio 2005 and later. If you are using
Visual studio version 2008 and later then you just need to change
connection string i.e "provider=microsoft.jet.oledb.4.0;data source="
& Application.StartupPath & "\Imperial.mdb;jet oledb:database
password='iihm';" To "provider=Microsoft.ACE.OLEDB.12.0;data
source=" & Application.StartupPath & "\Imperial.mdb;jet
If you find any other problem regarding project you could mail me then i would provide you relevant solution to it. You also need crystal report viewer minimum version 2005 or 5.0.
Hi Mike,This is great example for inesrt and update process. I just wonder, if I use checksum transformation in SSIS instead of using checksum() function like you did at SQL query , what different between those 2 methods? is the performance making different ? I know checksum transformation is using M5 algorithm while checksum function using hash index.Thanks,Jerry