Adding new column and inserting values to an exisitng excelsheet using SSIS/SSRS

Asked Aug 02 '16 at 10:01

Active Aug 02 '16 at 10:01

Viewed 28 times

I have an existing excel template as like below :

DATE 7/28/2016 7/29/2016 July MTD YTD

Call Activity

IB_Calls_Offered 22 29 52 52 52

IB_Calls_Answered 22 29 52 52 52

Sale 6 3 9 9 9

Everyday when my SP get executed , I need to add a extra column (as Current Date) and fill the corresponding data.

Kindly Suggest me how to do it by using SSIS/SSRS

asked Aug 02 '16 at 10:01

tapas kumar

Please post your SP. – BIDeveloper Aug 02 '16 at 10:15
In my SP I am inserting and calculating the corresponding values of the Column List of the table. – tapas kumar Aug 02 '16 at 10:18
Your question is difficult to understand. Posting all of the information (e.g. the relevant section of your stored procedure) will give you a better chance of getting an answer. It's up to you. – BIDeveloper Aug 02 '16 at 10:46

0 Answers0