Post reply

want to insert excel file data into table using ssis - format problem

  • September 16, 2011 at 9:12 am

    #248290

    hi

    HI i have created ssis package i took 'excel source' taking excel file but my problem is i need to take B7 value from excel file and insert it into database table please help because

    B7 values is generated from expression : =MAX($B$32:C284)

  • September 17, 2011 at 4:57 am

    #1382897

    hi I want to take value of date i.e '8/26/2011' , and value of NAV i.e '93737452.52'

    and want to insert into table i'm using 'excel source ' to take excel file made connection now Select 'Data access mode' in 'Excel source editor' as 'SQL command'

    now what command I need to write to get 'date' and 'NAV'value as I have pasted picture of excel file please let me know the further steps

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

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