using SSIS package in Visual Studio 2008

Question

0.00/5 (No votes)

See more:

1.i'm having a sql table with millions of records
2.when i'm sending a sql query with where condition to the sql table thousands of records are getting(sql query can be changed simultaneously).
3.Now i want to send that record to excel sheet.
4.All the Above Steps can be done with the help of SSIS package in Visual Studio 2008
how to do the above steps programatically

Posted 6-Dec-13 1:05am

Boothalingam

Updated 6-Dec-13 1:31am

v2

Add a Solution

Comments

[no name] 6-Dec-13 7:06am

What is your question..??

Boothalingam 6-Dec-13 7:08am

How to do the above steps programattically?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BrishPandey · Answer 1 · 2013-12-06T01:13:00

Hi,

Yes you can achive the above mentioned condition using ssis.

Create a project in ssis. then drag dataflow task from the tool box , double click on it
you will come to dataflow tab.
on this go to tool box its different then previous tool box

drag drop from source section sql data source.. configure to your db
then if you have to do some data filteration then you can use some of the filter tools avaiable
add excel file destination component on the tab and connect it though connector

run the program