Solved

ssis job

Posted on 2014-03-21
2
296 Views
Last Modified: 2016-02-10
I have already done some data flow task and sql task in SSIS and saved it. Nw I want to do this:
Open a destination workbook and grab all rows from “table1” in sql server and dump that in cell “A3” of worksheet “dataDump” of the destination workbook – now please tell me how I can accomplish this in the same SSIS job that I created. Do i write a c# code and insert a c# task in the SSIS job? How to do that?

Thank you
0
Comment
Question by:Rayne
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39946709
>dump that in cell “A3” of worksheet “dataDump” of the destination workbook
1   In your Excel file, pre-data pump, create a named range that is cell A3 for whatever tab we're talking about.
2   In your SSIS package, make sure the Excel connection specifically refers to the above named range.

>Do i write a c# code and insert a c# task in the SSIS job? How to do that?
A script task is not necessary.
0
 

Author Comment

by:Rayne
ID: 39947465
Thank you Jim, the destination excel  will be a .xlsm file type - this excel connection  will work for that?
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question