Post reply

Need to load excel cell in ssis

  • August 4, 2015 at 1:41 pm

    #299383

    Hi friends

    Excel file cell A7:B7: value to store in variable

    I use execute sql task for that but Execute sql task trow the error

    Error:[Execute SQL Task] Error: Failed to acquire connection "Excel Connection Manager 1". Connection may not be configured correctly or you may not have the right permissions on this connection.

    or any other alternative way then let me know.

    Thanks in advance

  • August 4, 2015 at 1:51 pm

    #1817307

    use a dataflow task with an Excel source and Excel connection

    Gerald Britton, Pluralsight courses

  • August 4, 2015 at 2:10 pm

    #1817313

    I need to read only one cell.

    not entire file

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

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