Solved

ssis job

Posted on 2014-03-21
2
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

749 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