Post reply

Problem Importing Excel data

  • August 11, 2011 at 6:40 am

    #242992

    Hi guys,

    I have to import lots of excel files to SQL Server. The problem is that the data on the sheets is very bad. There are some blank lines in the middle of the sheet, and in some of them there are four sheets inside one.

    Does anyone know if it is possible to run some VB code (or c# code) through SSIS to make the sheet more "readble"? Like deleting the blank lines, or the first ones...

    I receive the sheets this way and can not ask them to send me the files in other format, and i can not run macros inside the excel.

    Thanks!!!!

  • August 11, 2011 at 10:30 am

    #1367449

    MIKEKREIS (8/11/2011)

    Does anyone know if it is possible to run some VB code (or c# code) through SSIS to make the sheet more "readble"? Like deleting the blank lines, or the first ones..

    Yes, it is possible. You can use Excel objects within your .NET code to access worksheets within a workbook to clean it up before you attempt to import it using a Data Flow Task.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • August 11, 2011 at 10:35 am

    #1367452

    So what do i use, script task at control flow?

    I did not find any examples of this in the net.

  • August 11, 2011 at 10:38 am

    #1367455

    Use a Script Task.

    This is not strictly an SSIS problem. You may have better luck finding examples on .NET/Office-specific programming sites. Google/Bing will be your friend.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply