Problem: Read the data from flat/delimited file which has huge number of columns Solution: Currently i am working on few integration projects and interesting ones too. Especially the last one as i had to get my tool out of my…
Importing Data from a flat file to SQL Server using SQLBulkCopy
Problem: Import a file with over 600,000 records which is around 250MB size. The import needs to be quick.Solution: Recently i was tasked with a carrier integration project. Now this carrier configuratiion file conatined data for 160 diffrent columns of…
Importing Contact Details from Excel Sheet to OutLook
This post is dedicated to Jenny & Sarah who posed this problem to me. This originally arose from another problem. We recently migrated to Office365 . There are limits on the number of emails you can send using Office365 services.…