Exporting Database Data to Excel With Default Rows via SSIS or VB Script Task

Question

I really need help desperately,I have been goggling for hours but am unable to find a good sample for the following problem.

Currently I am able to export a Data table to excel via the format below

    Column 1   Column 2   Column 3   Column 4  
    Data-- x   Data-- y   Data-- z   Data-- u 
    Data-- x   Data-- y   Data-- z   Data-- u 
    Data-- x   Data-- y   Data-- z   Data-- u

But I require the Top 2 Row of the excel to be imprinted with a default set of data.

Example of what i need listed below

    Created by: xxxxx
    Date Created: xxxxxxxx
    Column 1   Column 2   Column 3   Column 4  
    Data-- x   Data-- y   Data-- z   Data-- u 
    Data-- x   Data-- y   Data-- z   Data-- u 
    Data-- x   Data-- y   Data-- z   Data-- u

Any workaround to add the default 2 row via SSIS /windows script/application that can be scheduled is greatly appreciated. Guide to any tutorial would also be good.

Thanks in advance for your help

Community · Accepted Answer · 2017-05-23 10:31:42Z

1

Let the SSIS export the data first, and manipulate the excel file at least. That means, after Data Flow task put a c# Script Task to open workbook, insert two lines and finally set the values of cells:

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Nov 12, 2013 at 10:33

makciook

1,56310 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting Database Data to Excel With Default Rows via SSIS or VB Script Task

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related