• subramani.rudrappa 78855 (11/16/2012)


    Hey Hi,

    I know we can use SSIS to get data from excel and load in to SQL table from where i can achieve requirements.

    I thought of using only SQL to get data from excel and achieve the requirements so that we need not to go for SSIS.

    I'm not aware of a way to use SQL directly. That is why Microsoft developed SSIS.