Category Archives: Excel

Removing Process from the memory – SSIS

Posted on April 17, 2013 by

We often use Task Manager to kill the unresponsive or unwanted process in the memory. I had a situation where I was using excel interop to automate some task in SSIS script task. But at the end of execution excel … Continue reading →

Posted in Excel, SSIS | Tagged , , , , , | Leave a comment

Export SQL Data to Excel – SSIS

Posted on February 14, 2013 by

We have got so many data formats to store data in digital world. Excel is one of the most famous format for data processing and storage. In this blog post I am going to use SSIS to export SQL data … Continue reading →

Posted in Excel, SSIS | Tagged , , , | Leave a comment

Get WorkSheet Names from Excel WorkBook

Posted on February 8, 2013 by

I was working on an excel to SQL Server data migration project today. In this project, I have got lots of excel files with multiple sheets in each file. So, I wrote a program to read excel meta data to … Continue reading →

Posted in Excel, SSIS | Tagged , , , | Leave a comment

Excel Data Type Guess Registry Setting

Posted on November 11, 2012 by

We already know that the excel make its own guess about the column data type in the excel sheet.  But, we can tell the excel reader to treat all columns as string by using IMEX property in the Excel connection string. … Continue reading →

Posted in Excel, SSIS | Tagged , , , | Leave a comment

Excel auto column data type detector

Posted on July 30, 2012 by

Excel Source reader task detects the column data type from Excel file automatically. But, this is not always helpful for developer to get the default settings from the excel source component. For instance, if a column in the excel file … Continue reading →

Posted in Excel, SSIS | Tagged , , , , , , , , , | Leave a comment