Extract the data from Excel sheet to MS word by SSIS

  • i want to pull the data from excel sheet to MS word document by SSIS Pkg. if is it possible. please let me know. how's possible.

    Thanks in advance !!!!!!!!!!!!!!!!!!!!!!!!!!!

    Regards,

    Hemant

  • Yes it is possible, use the Excell data source, perform any transformations that are needed, and send the data to a flat file destination.

  • then directly it is possible to pull the data from database to MS word Docuemt by SSIS pkg.

    Regards,

    Hemant

  • yes just use a database connection as the datasource

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

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